IF EXISTS( SELECT 1
FROM tempdb.dbo.sysobjects
where ID = OBJECT_ID(N'#tempOutput'))
BEGIN
DROP TABLE #tempOutput
END
------OR--------
IFOBJECT_ID(N'tempdb..#Temp') IS NOT NULL
BEGIN
DROP TABLE #Temp
END
BEGIN
DROP TABLE #Temp
END
No comments:
Post a Comment