How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?

I’m looking for a way to generate a “Create and insert all rows” script with SQL Management Studio 2008 R2.

I know that I can create a “create table” script.

I can also create an “insert in” script, but that will only generate a single row with placeholders.

Is there a way to generate an insert script that contains all currently stored rows?

4 Answers
4

Leave a Comment