Easiest way to Generate Insert Script in SQL Server

(Note: This blog post was originally published under my old domain(codesmiles.com), here. Web Archive link.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Copy link
Powered by Social Snap