淘先锋技术网

首页 1 2 3 4 5 6 7


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!