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?