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

This Week I Learned - Week 24 2026

High and Dry in Hyderabad