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 vote296 views1 answer
Selecting Multiple Columns in SQL
SQL
8 votes269 views2 answers
Mysql query dates between two dates
SQL
1 vote273 views3 answers
Psql fatal database does not exist
SQL
33 votes320 views6 answers
Sql delete
SQL
1 vote279 views1 answer
Mysql batch insert
SQL
0 vote311 views1 answer
How to get table id sequence postgres
SQL
1 vote263 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote328 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
16 votes281 views2 answers
Sql exists
SQL
13 votes290 views2 answers
Get tables in database sql
SQL