/SQL/Select into temp table

Select into temp table

Select into temp table

SELECT * 
INTO #temp
FROM (
    SELECT col1, col2
    FROM table1
) AS x

1

Source: stackoverflow.com

Select into temp table

SELECT t.col1, t.col2...
INTO #temp
FROM table1 AS t

0

Similar codes

0 vote337 views4 answers
User defined function sql
SQL
9 votes325 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes336 views4 answers
2nd highest salary in mysql
SQL
8 votes354 views2 answers
How to fetch data from database without last column
SQL
3 votes311 views1 answer
Make a field auto_increment mysql
SQL
3 votes308 views2 answers
Having in mysql
SQL
0 vote352 views1 answer
Check if string is a number sql
SQL
9 votes313 views2 answers
Get first 3 letters in sql
SQL
0 vote343 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote326 views2 answers
How to delete the rows with null values in mysql
SQL

Share