MSSQL Create temporary table code

MSSQL Create temporary table code

if object_id (' tempdb.dbo. #table ') is not null
drop table #table
Go
CREATE Table #table ([field] type)

The above code is to determine whether the temporary table #table exists, if it is deleted, otherwise create this temporary table.

/*
About MSSQL Server temporary table operations

Building temporary tables
Method One:

CREATE Table #临时表名 (Field 1 constraint,
Field 2 constraint conditions,
.....)
CREATE TABLE # #临时表名 (Field 1 constraint,
Field 2 constraint conditions,
.....)

Method Two:

Select * into #临时表名 from your table;
       select * into # #临时表名 from your table;
> Note: The above # represents the local temporary table, # #代表全局临时表

Query temp Table
     select * from #临时表名;
    & nbsp;  select * FROM # #临时表名

Delete temporary tables
     drop table #临时表名;
       drop table # #临时表名;