SQL Server 2008 How to export data to a SQL script file _mssql2008

See the operation diagram below.

1. Use SQL Server Management Studio 2008 to connect to the database.

2. Select the database node that you want to export data to, click the right mouse button, select "Task"-> "Generate Script" in the menu, as shown in figure:

3. In the pop-up interface, point 2 times "next" into the diagram interface, "Write the Footsteps of data" to true.

4. Other action points "next" can be. The following figure is the last generated SQL script:

NOTE: The SQL Server Management Studio 2008must be used here, and no other version is available.

SQL Server 2008 Exports data as a script

Starting with SQL SERVER 2008, we can easily export data scripts without resorting to stored procedures

(But there is a slight difference in the process of exporting scripts for SQL Server 2012 and SQL Server 2008)

Begin:

Select database to operate--right--"task---" Generate script

And then the next step >>

This data script is changed to true, which means that the data in the table is also generated by SQL script

And then the next step >>

Here you can choose your own and then the next step >>

And then the next step >>

Here you choose the Save path for the script, and then the next step >> next >> finish it.