In this step by step SQL tutorial I will show you how to use SQL INSERT INTO statement.
For the purpose of this tutorial I will use SQL Server 2008 R2.
Insert into is used to insert a row or rows into one table. Below is syntax.
INSERT INTO TableName
Below I Insert one row with values for three fields.
In Messages window you can see that 1 row is added after I executed my SQL Statement.
Once I added one row to my new Employee table I can use Select to display the new row. As you can see the rows was added.
I hope that this simples SQL Insert into example will help you.