Insert Delete Update MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Insert Delete Update
  4. 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]