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

5 votes173 views1 answer
Sql add column after another
SQL
10 votes164 views1 answer
Oracle dba_dependencies
SQL
3 votes190 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
2 votes166 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
4 votes160 views2 answers
Select first and last row mysql
SQL
3 votes161 views1 answer
Oracle limit user tablespace
SQL
-1 vote185 views3 answers
Error: mysql shutdown unexpectedly.
SQL
2 votes165 views1 answer
Oracle find unusable indexes
SQL
17 votes164 views2 answers
Mysql date to string
SQL
0 vote177 views1 answer
Sql get date from timestamp
SQL