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 vote159 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote161 views1 answer
Sql date time query find
SQL
0 vote144 views1 answer
Get rows from 1 table with other table empty mysql
SQL
1 vote140 views2 answers
Sql left characters
SQL
0 vote139 views1 answer
Group by two columns postgres
SQL
1 vote164 views1 answer
Sql server loop over query
SQL
0 vote133 views4 answers
Mysql desactivar trigger
SQL
1 vote136 views1 answer
Mysql query where in select
SQL
0 vote179 views1 answer
How to connect to xampp sql server on windows cmd
SQL
2 votes133 views1 answer
Mysql query unique column
SQL