Thursday, May 14, 2015

Generate Table Insert Statements from Visual Studio

I will admit that i don't use the Server Explorer pane in Visual Studio. Especially not for anything related to SQL Server. But i found this cool option while mucking around in Server Explorer that is worth sharing.

Did you know that you can create SQL insert Script right out of Visual Studio without adding any new plugin to your SSMS or Visual Studio application?

Right click the table in server pane that you want to script the data for and choose "Show Table Data" option

This will display the data like this

Notice the script toolbar button highlighted below.

Once you press that, your data in the table will be displayed as SQL Insert Statements

Doesn't require any special plugins and works beautifully.

This post was created using Visual Studio Professional 2013.