Go for the about Stored Procedure

Reference: http://www.sql-server-performance.com/2006/go-command/

First, you do not need to delete it once.

When you execute this exec magicprocedure, it will show that "you can not see me next time" cannot be found during execution.

Create proc magicprocedure as begin select 'You can not see me next time' end drop proc magicprocedure go ----------------

Second, you do not want to execute this exec magicprocedure once, prompting that the stored procedure cannot be found.

Create proc magicprocedure as begin select 'You can not see me next time' end go drop proc magicprocedure go