/*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
How to save SQL Server data as Insert INTO SQL Script
原文：http://blog.csdn.net/garcon1986/article/details/20728079