SQL Server 2008 Exports data as a script

Starting with SQL SERVER 2008, we can easily export data scripts without the need for a stored procedure

(But the process of exporting scripts for SQL Server 2012 and SQL Server 2008 is slightly different)

Begin:

Select the database to be manipulated--right--"task---" Generate script

Then the next step >>

This write data script is changed to True, indicating that the data in the table is also generated together with the SQL script
And then the next step >>
Here you can choose your own, then next >>
Then the next step >>
Here you choose the Save path of the script, then next >> next >> finish