Every now and then I need to create a SQL script to move
table data between environments or to simply load table during database
deployment process.
For a number of years I am using the stored procedure
created by Narayana Vyas Kondreddi (http://vyaskn.tripod.com).
This is a great tool for scripting data without any problems!
Attached script creates “sp_generate_inserts” stored procedure
in master database (so it is accessable from any database on the server).
The description portion in the script contains the complete description
of the parameters and usage examples.
You can get the script here:
This is what the output looks like:
