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 vote338 views1 answer
Login failed for user sql server
SQL
0 vote302 views1 answer
Remove default constraint sql server
SQL
3 votes323 views2 answers
Create schema postgres
SQL
0 vote355 views2 answers
Mysql insert into multiple tables
SQL
1 vote309 views1 answer
Mysql limit results to 10
SQL
0 vote325 views5 answers
Sql table intermédiaire
SQL
0 vote313 views2 answers
Sqlite unique
SQL
0 vote329 views1 answer
No query unable to fetch row sqlite
SQL
0 vote294 views1 answer
Oracle last connection
SQL
2 votes311 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL