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 shocould 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!