Wednesday, September 14, 2011

Inserting Multiple Rows in One Insert Statement In SQL SERVER 2008

You can insert multiple records with one insert statement. Syntax is:

Insert Into TableName (field1,field2)
VALUES 
(value1,value2),
(value3,value4)

Posted by at
Labels:

2 comments:

Subscribe to: Post Comments (Atom)