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 2000 Forums  SQL Server Development (2000)  single query to insert multiple record

Author  Topic  ajay Starting Member 34 Posts Posted - 2001-08-08 : 08:05:02 How can i insert multiple records in a table,Instead of using multiple insert statement to insert records in the same table. have to run in a loop ,insert statement which becomes very slow if no of records are more. thanks ajay