Generate INSERT statement in Management Studio



Let's see how to use SQL Server Management Studio to build a simple INSERT statement for you.


First, let's navigate to our table in SSMS located at root | Databases | Test | Tables as shown below:

Once we have the table list, right click on the table and select Script Table as | INSERT To | New Query Editor Window as shown below:

Following the steps above will generate this code:

As you can see, using SSMS will generate a simple INSERT statement template which you can modify for your needs.

Last Update: 9/16/2011

Comments For This Article


get free sql tips
agree to terms