Sql server insert into temp table

--This will create a temp table on the fly
SELECT last_name, first_name, hire_date, job_title 
INTO #tmp_employees
FROM dbo.employee
WHERE hire_date > '1/1/2010'

Similar codes

11 votes168 views1 answer
Oracle view source
SQL
0 vote156 views1 answer
Create table with float datatype in sql server
SQL
0 vote146 views1 answer
Compare subqueries oracle
SQL
0 vote166 views1 answer
Mysql aspas simples
SQL
0 vote146 views1 answer
Oracle last connection
SQL
6 votes139 views1 answer
Oracle trigger after connect
SQL
0 vote159 views1 answer
Postgresql array to rows
SQL
1 vote150 views1 answer
Postgresql transaction discard all
SQL
0 vote135 views1 answer
Full syntax inner join
SQL
0 vote144 views1 answer
Show size of all tables postgres
SQL