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!
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。