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 2005 Forums
 SQL Server Administration (2005)
 Generate "insertt statement" script?

Author  Topic 

markshen2006
Starting Member

15 Posts

Posted - 2008-04-05 : 12:08:39
Hi,

I have a table with data.I want to generate a SQL script with many insert statements.the data can import to same table when I run the script .

I remember I can do the work with a stored procedure,but I do not have a idea how to write the stored procedure.

I use SQL Server 2005 now.

Please give me a idea about this.Thanks

Mark

Mark

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-04-05 : 14:59:50
See this: http://vyaskn.tripod.com/code.htm#inserts

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -