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 vote282 views1 answer
Oracle sql procedure return value
SQL
1 vote271 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote303 views1 answer
Insert or update sql query
SQL
0 vote309 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote277 views1 answer
Min and max salary and name in sql
SQL
0 vote278 views1 answer
Sql recherche nom prenom
SQL
0 vote277 views1 answer
Replace multiple string in query sql
SQL
1 vote287 views1 answer
Top 10 rows in mysql
SQL
-1 vote250 views1 answer
Mysql if example
SQL
0 vote317 views1 answer
Sqlalchemy _in array sqlite
SQL