The syntax of the SELECT INTO statement : Select Into « Query « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Query
  3. Select Into
SELECT select_list
INTO table_name
FROM table_source
[WHERE search_condition]
[GROUP BY group_by_list]
[HAVING search_condition]
[ORDER BY order_by_list]








1.29.Select Into
1.29.1.The syntax of the SELECT INTO statement
1.29.2.Using the INTO Clause
1.29.3.Using SELECT INTO to Create an Empty Table
1.29.4.Creating a NULLable Column Using SELECT INTO
1.29.5.A statement that creates a complete copy of the Billings table
1.29.6.Using INTO clause with where clause