-- Create test temp. procCREATE PROC #tempMyProc asBegin print 'Temp proc'ENDGO-- Drop the above procIF OBJECT_ID('tempdb..#tempMyProc') IS NOT NULLBEGIN DROP PROC #tempMyProcEND