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 vote153 views1 answer
Drop domain postgresql
SQL
0 vote120 views1 answer
Sql select min
SQL
0 vote118 views1 answer
Turn on foreign keys check mysql
SQL
0 vote118 views1 answer
Sql where part of string match
SQL
18 votes112 views4 answers
Foreign key mySql
SQL
0 vote130 views1 answer
Sql remove non numeric characters
SQL
8 votes151 views1 answer
Racle create auto increment column
SQL
13 votes134 views2 answers
Sqlite rename table
SQL
3 votes110 views1 answer
Mysql insert on dupèlicate
SQL
0 vote140 views3 answers
Call to undefined function mysql_connect()
SQL