HOW TO check if a temporary table exists before DROPping

To check if a temporary table already exists before DROPping, use

If Object_Id('tempdb..#big') is Not Null

Drop table #big

BTW, Are SQL Server Temp Tables Really Necessary?


Comments

Popular posts from this blog

Datawrapper Makes Data Beautiful & Insightful

GitHub Copilot Q&A - 1

This Week I Learned - Week #3 2025