Adding New Rows with INSERT

Use the INSERT statement to add rows to a database with the VALUES keyword or with a SELECT statement.

The VALUES keyword is used to specify values for some or all columns in a new row. This is the simplified syntax for the INSERT statement using the VALUES keyword:

INSERT table_name
VALUES (constant1, constant2, ...)

You can also use a SELECT statement in an INSERT statement to insert values selected from one or more other tables or views. This is the simplified syntax:

INSERT table_name
SELECT column_list
FROM table_list
WHERE search_conditions

For details on the INSERT statement, see the INSERT statement in the Microsoft SQL Server Transact-SQL Reference.