CRUD Statements  «Prev 

Transact-SQL INSERT Syntax

table_name is the name of the table to insert data into

table_hint instructs SQL Server on which index to use if you want to choose a different index from that chosen by the query optimizer. See the graphic below for the table_hint syntax.

view_name is the name of the view to insert data into

rowset_function is the OPENROWSET or OPENQUERY function, if used.

column_list is the list of columns to insert data into

Expression is any valid SQL Server expression

derived_table is the result of any valid SELECT statement that returns rows of data

execute_statement is any valid EXECUTE statement that returns SELECT data. The columns that are returned from the SELECT statement must have datatypes that are compatible with each column in the INSERT statement