Sql

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

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

PREVIOUS	NEXT

Code Example
Sql :: download mysql 64 bit
Sql :: not exists mysql
Sql :: sql compare strings
Sql :: select new table sql
Sql :: oracle first row
Sql :: create a sqlite database c#
Sql :: sql pagination
Sql :: show table postgres command
Sql :: mysql disable query caching
Sql :: oracle log files
Sql :: windows services sql
Sql :: sql drop column
Sql :: sql server change schema of a table
Sql :: sql convert varchar to date
Sql :: mysql delete duplicate rows but keep one
Sql :: postgres regular expression replace
Sql :: postgresql combine values in one field
Sql :: how to drop a unique constraint in sql
Sql :: create or replace function
Sql :: run postgresql dump to csv
Sql :: mysql get last inserted id
Sql :: update with inner join sql server
Sql :: mysql collation for all languages
Sql :: convert multiple columns to rows in sql server
Sql :: oracle shrink table
Sql :: sql select rows with different values in one column
Sql :: sql number columns
Sql :: restart serial number for postgres
Sql :: sql server drop database
Sql :: oracle all_dependencies