Procedure to script your data (to generate INSERT statements from the existing data)

This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes.

For more information, have a look at the website of the author (http://vyaskn.tripod.com/code.htm#inserts).

The procedure itself can be found here: http://vyaskn.tripod.com/code/generate_inserts.txt