SQL Server INSERT Command Tutorial

By: Jeremy Kadlec

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

• 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