IF object_id('tempdb..#MyTempTable') IS NOT NULL
BEGIN
DROP TABLE #MyTempTable
PRINT 'Table dropped'
END
CREATE TABLE #MyTempTable
(
ID int IDENTITY(1,1),
SomeValue varchar(100)
)
GO
Advertisements
Checking for the existence of a temporary table
- Leave a comment
GCFE
GIAC Certified Forensic Examiner
GCIH
GIAC Certified Incident Handler
Stackoverflow
Stackoverflow
LinkedIn
RSS Feed
Advertisements
