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:
