SQL Server INSERT Command tutorial and example

solving sql server problems for millions of dbas and developers since 2006

Top SQL Server Tools

dbForge SQL Complete

SQL compliance manager

SQL safe backup

SQL Monitor

SQL diagnostic manager

Tutorial Menu

Introduction Sample table Simple INSERT Example Verify Inserted Data INSERT with variables INSERT Stored Procedure Auto Generate INSERT INSERT with IDENTITY INSERT SELECT SELECT INTO

SQL Server INSERT Command

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

Sponsor Information

Try the free performance monitoring tool from Idera!

SQL Monitor, server monitoring so easy, your boss could do it. Try it online.

What grade do you think your SQL Servers get? Find out with Edgewood's SQL Server Health Check starting at $995.

Get SQL Server Tips Straight from Kevin Kline.

Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now.

Learn SQL Server 2012, Performance Tuning, Development, Administration, Replication and more - free webcasts