Does anyone use the [ ; number ] option when creating a procedure (CREATE PROC [ EDURE ] procedure_name [ ; number ] )?
The only way this seems to be usefull is for being able to drop several procedures with just one command. I tried this script:
CREATE PROCEDURE Test;1 AS
CREATE PROCEDURE Test;2 AS
DROP PROCEDURE Test
and only "1" showed up in the output. It would've been more useful if both stored procs had executed with just one "EXEC".
If this is all it is good for, I wouldn't ...