Easiest way to Generate Insert Script in SQL Server

We all know that there is no handy built-in command for generating insert statements for the data present in a table in SQL Server (apart from issuing a Generate Scripts… command on the Database and choosing to Script Data also).

sql-server-generate-insert-statements-ssmstools

There is this tool called SSMS Tools pack which I am using for years that provides a handy way to generate scripts for various purposes including Insert statements when you just right click the table for which you need the scripts.

sql-server-generate-insert-statements

You can get the complete set of features provided by the tool here.

I’ll try to post about other cool features of SSMS Tools Pack in future.

Bookmark / Share