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
 Transact-SQL (2000)
 Creating insert statements

Author  Topic 

sqllearner
Aged Yak Warrior

639 Posts

Posted - 2005-04-28 : 19:06:58
How can I create insert scripts from a table.Say I have 500 records in the table and I want to create 500 insert statement for the data in the table.Is there any easy way of handling these.Please help me with this

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-04-28 : 19:08:50
Try this:

http://www.mindsdoor.net/SQLTsql/sp_CreateDataLoadScript.html

There are other ways to import data into SQL Server, bcp and BULK INSERT for instance, that are more efficient than using INSERT statements. Books Online has more information on them.
Go to Top of Page
   

- Advertisement -