Sometimes I need to generate insert statement, taking data from a starting database. Suppose you need to create sql installation scripts to create a database from scratch, quite often you need also to insert some initial data into some tables.
Sql server management studio does not provide a simple way to take a table and script all its content into INSERT statement, but a simple solution can be found here. This solution is really simple, it creates a stored into the database that can be used to generate data Es.
And this produces
This is really what I need, great script.
Tags: Sql Server