To Create Temporary Table
database #database#table
--local temporary table:
create table #tablename (column1 datatype, column2 datatype)
--global temporary table:
create table ##tablename (column1 datatype, column2 datatype)--local temporary table:
create table #tablename (column1 datatype, column2 datatype)
--global temporary table:
create table ##tablename (column1 datatype, column2 datatype)