SQL Temp Table Drop/Create

This is a tip to drop/create temp tables in Stored Procedures;

IF OBJECT_ID('tempdb..#add') IS NOT NULL DROP TABLE #add
SELECT 
   ...
INTO #add
FROM MyTable

Add to favorites