if object_id(N'tempdb..#MaxTransaction') is not null drop table #MaxTransaction
IF OBJECT_ID(N'tempdb..#RequestingBrokers') IS NOT NULL
BEGIN
DROP TABLE #RequestingBrokers
END
GO
IF OBJECT_ID('tempdb.dbo.#SeatStatus', 'U') IS NOT NULL
DROP TABLE #SeatStatus;
-- 'U' is object type : U = Table (user-defined)
IF OBJECT_ID('tempdb..#abc') IS NOT NULL DROP TABLE #abc
GO
select * into #abc from District where DistrictId=1
select * from #abc