Tag: "management studio"

Scripting Table Data with SQL Server 2008 R2

I recently was asked, whether the Feature “Script Data” as T-SQL-command INSERT INTO… has been removed in SQL Server 208 R2.

In fact, it was not visible on first sight.

This is how you can find it:

It is still the right-click “Tasks” - “Generate Scripts” –Wizard.

After having chosen the Table(s), the following window appears:


there click “Advanced” and scroll down inside the “General”-part until the Element “Types of data” to script


And there under the following drop-down, it is hidden:


And the German translation “Datentypen, für die ein Skript erstellt wird”, makes it even harder to detect:


Conclusion: Scripting out Data with “INSERT INTO”-commands is a bit hidden – (under SQL 2008 it was under the “Table/View Options”, now under “General” – “Types of data to script”) but still available :-)