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 vote347 views1 answer
Running mysql from bash sc
SQL
0 vote370 views1 answer
Python dictionary to sql update
SQL
8 votes354 views1 answer
Oracle current date plus 1 month
SQL
2 votes351 views3 answers
How do I add a user to a postgres database? cli
SQL
8 votes301 views2 answers
Phpmyadmin password
SQL
0 vote335 views1 answer
SELECT statement to find the specific cell in database table
SQL
4 votes330 views1 answer
Mysql copy table with new name
SQL
1 vote334 views1 answer
Load mysql dumb
SQL
0 vote318 views1 answer
Set column width in sqlplus
SQL
1 vote331 views1 answer
Get table column names sql ssms
SQL