How to save SQL Server data as Insert INTO SQL Script

/*Author : Jiangong SUN*/

If you have wondered to clean a table data, and want to save the original data in a backup sql script. 

Here is a solution for it.

Right click your database ->  click "Tasks" -> then click "Generate Scripts"

Then you will see an interface : "Generate scripts for database objects", 

->click "Next",  then "Select specific database objects",  

-> then "Tables" with specific tables.

-> "Specify how script should be saved or published", and click "Advanced" , In the options, choose "Types of data to script" and modify it to "Data only".

-> click "Next" and then finish.

And then your "INSERT INTO" scripts are generated.

I hope this post can do help to your work!