How to generate insert statement for existing data in SQL Server Management studio?

First of all download the SSMS Tools pack set up file from the below link. www.ssmstoolspack.com/Download Just Double click the downloaded set up file and install like this.




After installation check whether the SSMS tools pack add in the SQL Server Management Studio like below screen.




I have explained below how to take up back up particular table data with different requirement.
Select Database table which ever data you want back up. Then right click of the table and select SSMS Tools --> Generate Insert Statement .





After select "General Insert statement" new pop up window is appear like this




In that pop up window click"Generate Scripts" button for generate insert statement. Results come like this with all data and its database name etc.




In the pop window first option number of rows "0" (it denotes create insert statement for all records in the table) if you change any other number in the option then can you get that particular row. For example if you put "2" in that option, then Insert statement is generate with first two rows of your selected table.




Result:




In the pop window second option is used for enter custom defined condition you can use where or order by conditions in that option. So resulted inserted statement is generated based on your condition.




After you generate insert statement script just execute that script in other PC. If database name is different in that PC then change first line database to new Database name.

Result:




Conclusion:
Using this SSMS Tools pack feature we can generate insert statement for several data within a single minute. And also this feature is used to take partial backup (single table and its data) in the SQL Server database. I hope this article is help to you for know about SSMS tools pack usage.