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')
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
Reviewed by Anonymous
on
Saturday, April 06, 2013
Rating:
Reviewed by Anonymous
on
Saturday, April 06, 2013
Rating:

No comments: