Date: 01/03/06 (SQL Server)    Keywords: database, sql

Just joined. Looks like a nice comm.

Quick question:

I have a production database that is about 1 GB in size. I have been tasked to script that baby out into sql files. The tables, procedures, etc. should be little problem (thanks to the database scripting wizard), but the data is eluding me. How can I (relatively automated) script table data into a series of INSERT statements?

Is there any way to avoid manually typing:
"INSERT INTO tbl_WHATEVER (ID, FIELD1, FIELD2, ...) VALUES (1, 1, 1, ...)"?

Thanks in advance!

Source: http://www.livejournal.com/community/sqlserver/39390.html