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

8 votes287 views1 answer
Oracle search text in all packages
SQL
1 vote266 views1 answer
How to find median of a column sql
SQL
1 vote284 views1 answer
Postgresql float 2 decimal places
SQL
2 votes255 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote281 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote255 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote275 views1 answer
Xamarin sql lite create table if not exist
SQL
4 votes256 views4 answers
Update select mysql
SQL
0 vote259 views1 answer
Can sqldatareader be null
SQL
0 vote252 views1 answer
We are intrested to work with your organization
SQL