Answered by : henry-petersen

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO

Source : | Last Update : Wed, 29 Apr 20

Answered by : kind-kangaroo-jb9m9n2ui4f0

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results

Source : https://stackoverflow.com/questions/659051/check-if-a-temporary-table-exists-and-delete-if-it-exists-before-creating-a-temp | Last Update : Tue, 06 Apr 21

Answered by : bismythos

IF OBJECT_ID('tempdb..#abc') IS NOT NULL DROP TABLE #abc
GO
select * into #abc from District where DistrictId=1
select * from #abc

Source : | Last Update : Sun, 21 Aug 22