-- Create test temp. proc CREATE PROC #tempMyProc as Begin print 'Temp proc' END GO -- Drop the above proc IF OBJECT_ID('tempdb..#tempMyProc') IS NOT NULL BEGIN DROP PROC #tempMyProc END
