Insert Data into Tables in SQL Server using INSERT Statement

The INSERT INTO statement is used to insert single or multiple records into a table in the SQL Server database.

Syntax:

INSERT INTO table_name(column_name1, column_name2...) VALUES(column1_value, column2_value...);

Here, we will insert data into the following Employee table which we created in the Create Table chapter.