/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

3 votes187 views2 answers
Savepoint in sql
SQL
0 vote176 views1 answer
Multiple like values for single column postgres
SQL
0 vote163 views1 answer
Export partttion and import in oracle
SQL
9 votes180 views4 answers
SQL Date Format
SQL
0 vote176 views1 answer
How to check the port of mysql installation in mac
SQL
1 vote176 views1 answer
Mysql data from file
SQL
0 vote185 views1 answer
Logtash mysql cofiguration file
SQL
0 vote200 views1 answer
How to pass list as parameter in SQL query
SQL
1 vote165 views1 answer
Sql server reseed single table
SQL
8 votes185 views10 answers
Sql
SQL

Share