banner image

HCL INTERVIEW QUESTION

How insert multiple record in a table using one insert statement in sqlserver 2008? means what is the new way of inserting multiple records in sql server 2008?
SQL server 2005 OLD way
Insert into Companies select 'EnigmaSoft'
union all select 'WebCatalyst'
union all select 'Awarebase'


SQL server 2008 NEW way
Insert into Companies values('HCL'),('Oracle'),('Infosys')
HCL INTERVIEW QUESTION HCL INTERVIEW QUESTION Reviewed by Anonymous on Saturday, April 06, 2013 Rating: 5

No comments:

Ad Space Available

banner image
Powered by Blogger.