Click here to Skip to main content
12,945,401 members (81,912 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
can i put where clause in INSERT query if yes how
Posted 17-Nov-12 23:08pm
Comments
Shanalal Kasim 18-Nov-12 5:14am
   
Provide more details
Nelek 18-Nov-12 5:24am
   
It is possible, but if it makes sense or not, and how to use it... it depends on what you want/need to do. So please use the widget "improve question" and give a bit more information

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

No: Insert is about adding records, so you can't insert based on existing records.
See: http://www.w3schools.com/sql/sql_insert.asp[^]
And: http://msdn.microsoft.com/en-us/library/ms174335.aspx[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 4,781
CHill60 3,135
Maciej Los 2,443
Jochen Arndt 1,910
ppolymorphe 1,765


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 18 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100