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

1 vote193 views1 answer
Select random sample sql
SQL
3 votes216 views2 answers
Synonym oracle
SQL
4 votes179 views1 answer
What are the data types in sql
SQL
7 votes193 views2 answers
N highest salary in sql
SQL
0 vote186 views1 answer
Dbms_output sql developer
SQL
0 vote181 views2 answers
Show slave status mysql
SQL
-1 vote185 views1 answer
Round up and down sql
SQL
8 votes227 views2 answers
Sqlsrv default port
SQL
1 vote183 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote176 views1 answer
Mysql case when null
SQL