How to export the Insert Data statement from the SQL Server database

In SSMS of the Object Explorer, right click on the database right-click and pick "Tasks" and "Generate Scripts".

This would allow you to generate scripts-a single or any tables, and one of the options is "Script Data". If you set this to TRUE, the wizard would generate a script with INSERT in () statement for your data.

NB if using R2 or its called something else, see screenshot below this one

R2 or later eg 2012

Elect ' Types of data to Script ' which can be ' data only ', ' schema and Data ' or ' schema only '-the default.

And then there's a "SSMS Addin" package on Codeplex (including source) which promises pretty much the same functionality a nd a few more (like Quick find etc.)

For the sake of over-explicit brainlessness, after following marc_s ' instructions ...

In SSMS of the Object Explorer, right click on the database right-click and pick "Tasks" and "Generate Scripts".

... I then see a wizard screens with "Introduction, Choose Objects, Set Scripting Options, Summary, and Save or Publish SCR IPTs"With Prev, Next, Finish, cancel buttons at the bottom.

On the Set Scripting options Step, you have a to click ' Advanced ' to get the page with the options. Then, as Ghlouw have mentioned, you now select the "Types of data to script" and profit.

How to export the Insert Data statement from the SQL Server database