Overview
Let’s see how to use SQL Server Management Studio to build a simple INSERT statement for you.
Explanation
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.
Jeremy Kadlec is a Founder, Editor and Author at MSSQLTips.com with more than 300 contributions and 25+ years of SQL Server experience. Jeremy leads a team of more than 300 authors helping millions of SQL Server professionals around the globe every second of the day for the last 20 years. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP based on his community contributions. Jeremy brings 25+ years of SQL Server DBA and Developer knowledge to the community and holds a bachelor’s degree from SSU and master’s degree from UMBC.
