Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  Row Value Constructor insert statement..

Author  Topic  bobby170 Starting Member 1 Post Posted - 2010-03-24 : 03:53:04 Hi, I tried inserting 1000 records using the row value constructor in sql server 2008. insert into MyTest1 (id ,fname ,lname , salary) values (1 , 'John' , 'Smith' , 150000.00),(2 , 'Hillary' , 'Swank' , 250000.00) The problem i faced was its taking long time(32 secs.).When i inserted the same 1000 records in the same table using following insert into MyTest1 (id ,fname ,lname , salary) values (1 , 'John' , 'Smith' , 150000.00); insert into MyTest1 (id ,fname ,lname , salary) values (2 , 'Hillary' , 'Swank' , 250000.00); it took only 1 sec. Can someone explain what the problem with the row value constructor.BTW the table does not have any index. -Thanks, Bobby