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
GCIH Certified
Stackoverflow
LinkedIn
RSS Feed
Visits since 2/27/2014
Advertisements
