/*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!
How to save SQL Server data as Insert INTO SQL Script,布布扣,bubuko.com