Inserting a new row of data into a table (INSERT command)
Use the INSERT command to insert a new row of data into an existing table.
Syntax
INSERT INTO [database_name.]table_name
[ (column_name,...) ] VALUES (expression,...);
You must specify a value for every primary key column in the table.
If you are inserting values for every column in the row, specify the VALUES keyword followed by a comma-separated list of column values in parentheses. Enter the values in sequential column order.
If you are not inserting values for every column in the row, specify a comma-separated list of columns being inserted in parentheses, followed by the VALUES keyword, followed by a comma-separated list of column values in parentheses. Enter the values in the same sequence as the specified columns. All other columns are populated with default values.
Example
To insert an alert into the mydb.mystatus table specifying the values in the indicated columns, enter:
insert into mydb.mystatus (Identifier, Severity, LastOccurrence)
values ('MasterMachineStats15', 5, getdate);