Mega Code Archive

 
Categories / MSSQL Tutorial / Insert Delete Update
 

The syntax of the INSERT statement for inserting rows selected from another table

INSERT [INTO] table_name [(column_list)] SELECT column_list FROM table_source [WHERE search_condition]