You should always know why this is working if you dn't know ask experts

in below examples it creates the procedure with name 'GO' just like 'CREATE PROC uspGO' it takes the character as a procedure name not as a GO keyword.

CREATE PROC GO AS BEGIN

EXEC ('ALTER PROC GO AS SELECT NULL')

EXEC GO

DROP PROC GO

END

GO

EXEC GO