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). 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. 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.