Insert Statement in SQL Server

Insert Statement in SQL Server

The INSERT INTO T-SQL statement is used mainly to add one or more rows to the target table or view in SQL Server. This can be done by providing constant values in the INSERT INTO statement or provide the source table or view from which we will copy the rows.

The INSERT INTO T-SQL statement syntax that is used to insert a single row into a SQL Server database table or view is like:

INSERT INTO table (column1, column2, … )

VALUES (expression1, expression2, …);