Ever tried the code-efficient, want-to-have function of running a remote stored procedure and insert the…
Ok, i might be the last person on earth to know about this but here it goes:
The other day a customer approached me with a question: ”Is there a way to generate insert statements, with the data included, for a specific table ?”
My immediate thought was that surely Management Studio incorporates this kind of functionality.
I started to right click on a table just to see what options there are.
Immediately i saw: Script Table as -> Insert To -> New Query Editor Window…
Alright here we go, another – soon to be, satisfied customer!
Well, not really…what i got was an insert statement with all the columns – INSERT INTO Table(Columns) VALUES(Columns), not the data.
So back to square one, regroup, rethink…
Next thing that came to mind was right click on the database -> Tasks -> Generate Scripts…
Another wizard starts. Here i chose to script a specific table and click next. In the next step in the wizard there is a button – ”Advanced” which shows us the Advanced Scripting Options.
Here i finally found what i was looking for: In ”Types of data to script” i can choose: ”Schema and data” which was exactly what i was looking for.
I finish the wizard and script the result to a new query window. And there is was, exactly as i wanted. Insert statements for every row in the table WITH the data.
There we go, another happy customer!