Inserting Values

Inserting Values

You can use a VALUES clause in an INSERT statement to specify literal values to insert into a table. The following example inserts a new row into the Course table of the sample database:

INSERT INTO Course
VALUES ('ART 103', 'Principles of Color', 3, 'Art');

In this example, listing the columns Name, Description, Credit_Hours, and Dept_Name is optional because the statement inserts a value for each column in the table, in order. However, a column list is required if the statement inserted data only into selected columns instead of the entire row, or if the statement inserted data into the columns in a different order than is defined in the table.

For complete information on the INSERT statement, see the following topic in SQL Engine Reference: INSERT.