Overview
I need to be able to add data to my tables. I have found the INSERT command, but I want to find out if you can provide me with some examples. I am hoping to see some code examples to see if I can pick-up any tips or tricks. Check out this tutorial to learn about the SQL Server INSERT command.
Explanation
You are correct, the INSERT command is used in SQL Server to add records to a table. It is a fairly straightforward command that can be used in ad-hoc code and stored procedures. Let’s cover the following topics in this tip:
- Sample table
- Simple INSERT statement
- Verify the INSERT commands
- INSERT command with variables
- INSERT stored procedure
- Automatically generating an INSERT statement in SQL Server Management Studio
- INSERT INTO a SQL Server table with IDENTITY column
- INSERT INTO a SQL Server table with a SELECT statement
- INSERT INTO a new table with the SELECT INTO command in SQL Server
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.
