My initial thoughts on reading this was "1 Procedure, the second generates an error". Finding no option for this, I went for "None, a error will be raised."
Reading the explantion, I put this through Server Management Studio to see this procedure that has two lots of code, only to get: None - error raised. Specifically "Msg 102, Level 15, State 1, Procedure SelectTest, Line 1 Incorrect syntax near ';'"
I refreshed, did it again, etc, but I still have no procs at all - let along 1 proc with both codes!
So I shut down Management Studio, restarted, checked, executed code, and got "Command(s) completed successfully." But still no procs! Indeed, I can keep on running it with no DROP statements and it will always be successful. (But with no procs.
So, what am I missing?