Inserting a Row by Using INSERT and Values

The VALUES keyword specifies the values for one row of a table. The values are specified as a comma-separated list of scalar expressions whose data type, precision, and scale must be the same as or implicitly convertible to the corresponding column in the column list. If a column list is not specified, the values must be specified in the same sequence as the columns in the table or view.

For example, the following statement inserts a new unit of measure into the UnitMeasure table by using the VALUES clause.

USE AdventureWorks;
INSERT INTO Production.UnitMeasure
VALUES (N'F2', N'Square Feet', GETDATE());

To insert data by using INSERT

INSERT (Transact-SQL)

Community Additions