SQL Server exports a script with data

Description

        has previously exported data from one table to a script, only with stored procedures. A new feature is now added in SQL Server 2008, which supports exporting data from tables to scripts in addition to the definition of the exported table.

step :

     Right-click the database for which you want to export data, select the Generate Script option under tasks in the pop-up menu

       in the second step, select "Advanced Options" script to write data "Select True, here default is False   ,

Yes, R2. Select the type of data to write script to schema and data

 

(2008R2)