SQL Queries for creating Temporary and Global Temporary Tables

--Creating Temporary Table
create table #table1(col1 int)
insert into #table1 values(3)
select * from #table1

--Creating Global Temporary Table
create table ##table2(col2 int)
insert into ##table2 values(4)
select * from ##table2

Cheers..!!
https://techiesss.blogspot.in/