In SQL Server 2008 we can insert multiple rows in one SQL statement:
create table table1 ( col1 int, col2 int ); insert into table1 (col1, col2) values (1, 1), (2, 2), (3, 3);
Don’t forget the semicolon. This will be required in SQL Server 2011.
In SQL Server 2008 we can insert multiple rows in one SQL statement:
create table table1 ( col1 int, col2 int ); insert into table1 (col1, col2) values (1, 1), (2, 2), (3, 3);
Don’t forget the semicolon. This will be required in SQL Server 2011.
No comments yet.
Leave a Reply