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

0 vote277 views1 answer
Mysql grant grant option
SQL
0 vote305 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote276 views1 answer
Split string by comma in sql server
SQL
0 vote293 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote283 views1 answer
Get date ISO in psql
SQL
0 vote274 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote270 views1 answer
Mysql backup certain tables workbench
SQL
1 vote271 views1 answer
Postgresql contains
SQL
5 votes257 views1 answer
Oracle get nls settings
SQL
0 vote278 views1 answer
T-SQL Never ending DELETE
SQL