SQL

create temp table in sql

-- CREATE TEMP TABLE 
Create Table #MyTempTable (
    EmployeeID int
);

create temporary table sql

-- CREATE TEMP TABLE 
Create Table #MyTempTable (
    EmployeeID int
);

-- DROP TEMP TABLE
IF OBJECT_ID('tempdb..#MyTempTable') IS NOT NULL DROP TABLE #MyTempTable

create temp table sql

IF Object_ID('tempdb..#Tablename') IS NOT NULL DROP TABLE #Tablename

Select
	*
into 
	#Tablename
FROM 
	SampleTable

Create Temp Table SQL

If(OBJECT_ID('tempdb..#temp') Is Not Null)
Begin
    Drop Table #Temp
End

create temporary table sql

declare @table table (id int)
create table #table (id int)
create table ##table (id int)
select * into #table from xyz

declare table temporary sql server

declare table sql server