May 4, 2005 at 1:12 pm
Could anyone explain:
what is the difference between "insert" and "insert into"?
And, also, please include the source of the explaination.
May 4, 2005 at 1:18 pm
Same thing except that insert into is the ainsi standard that you should use.
May 4, 2005 at 1:19 pm
If your question is only regarding relational data then BOL says:
[INTO]
Is an optional keyword that can be used between INSERT and the target table.
However, if it is about "analysis services programming" then BOL would be a good place to start...
hth
**ASCII stupid question, get a stupid ANSI !!!**
May 4, 2005 at 4:53 pm
Thanks a lot!!!
June 1, 2012 at 12:53 am
In Sql Server
If you are using Insert or Insert into both will insert the data in Table.
However Insert into is basically used to fatch the data from another table using select command and insert into table where you want to insert the data.
Insert command is simply used to insert data
June 1, 2012 at 12:58 am
soniarajput1988 (6/1/2012)
However Insert into is basically used to fatch the data from another table using select command and insert into table where you want to insert the data.Insert command is simply used to insert data
Nope, the two are completely the same, the INTO keyword is simply optional on an insert.
Maybe you're thinking of SELECT ... INTO
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply