sp_generate_inserts
Recently, I was doing some development where I created some new tables in the MSSQL database. I completed the task and needed a way to promote the tables (with data) to the QA database and eventually to production. Although it's certainly posssible to do this with DTS I wanted a simple text-based sql script to do the task as we have limited ability to create DTS jobs on production and it's easier to manage with source control. This is a trivial task to do with MYSQL but apparently not something that the MSSQL engineers thought about. Fortunately, a fellow named Vyas created a stored procedure sp_generate_inserts that does exactly what I need. When you run this proc against a table it creates a series of insert statements that repro the current data in that table.
Part 2 of the CFEverywhere article series is now online. This article describes how you can package a Derby database with your CFEverywhere application. You can check it out at 
