The syntax of the INSERT statement for inserting rows selected from another table : Insert into select « Insert Delete Update « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Insert Delete Update
  3. Insert into select
INSERT [INTO] table_name [(column_list)]
SELECT column_list
FROM table_source
[WHERE search_condition]








2.2.Insert into select
2.2.1.The syntax of the INSERT statement for inserting rows selected from another table
2.2.2.INSERT. . . SELECT constants
2.2.3.INSERT statement with a column list and select clause
2.2.4.Use insert...into...select in a stored procedure
2.2.5.Inserting Rows from Another Table