SQL Server R2 How to export data scripts

I used to see some friends who said that SQL Server 2008 must be able to export scripts that contain data, and then carefully investigate the fact that SQL Server R2 is also available, just set it up in advanced when exporting.

1. First right-click on the database to select the task and generate the script.

2. Select the table you want to manipulate in the pop-up window and click Next.

3. Click the Advanced button on the window.

4. Pull the scroll bar to the bottom to see the "type of data to script", select the schema and data in the drop-down, or just the data, other options can be set by themselves and then determined.

SQL Server R2 How to export data scripts