The only odd thing is the use of the word GO to name the procedure...

However, GO is not listed as a reserved word in SQL, so why not?

The first batch creates the procedure

The second runs the procedure that was created in the first batch

The procedure deletes itself at run-time.

Any good reasons why it shouldn't work?