Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

INSERT

The INSERT statement is used to add rows of data to a table. The INSERT statement specifies the table to which rows are to be added, the columns in which the data is to be stored, the source of the data being added, and the data itself. The components of the INSERT statement are described in Table 21.6.

Table 21.6. Components of a SQL INSERT Statement

Component	Description
INSERT INTO	Specifies the table to which rows are to be added.
column list	Specifies columns in which to add the data. (It is only necessary to provide a column list when not all the table's columns are to have data added and if you are inserting all the columns in a different order.) If left blank, the column list can be understood to be every column in the table, in the ...