Just posting this here because I can never remember this simple way myself:
--If the Temp Table called 'tmp' exists, DROP it IF Object_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp
Just posting this here because I can never remember this simple way myself:
--If the Temp Table called 'tmp' exists, DROP it IF Object_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp