What is purpose of semi colon after procedure name

[jw56578@gmail.com]

I've seen some system sp's that have a semi colon and number after the
the name such as
create procedure sp_procedure_pa rams_rowset;2
what does this do?

[Gert E.R. Drapers]

Re: What is purpose of semi colon after procedure name

This is a versioning mechanism, see BOL CREAT E PROCEDURE

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp

;number

Is an optional integer used to group procedures of the same name so they can
be dropped together with a single DROP PROCEDURE statement. For example, the
procedures used with an application called orders may be named orderproc;1,
orderproc;2, and so on. The statement DROP PROCEDURE orderproc drops the
entire group. If the name contains delimited identifiers, the number should
not be included as part of the identifier; use the appropriate delimiter
around procedure_name only.

GertD@SQLDev.Ne t

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

<jw56578@gmail. com> wrote in message
news:1117941858 .290608.88360@g 49g2000cwa.goog legroups.com...[color=blue]
> I've seen some system sp's that have a semi colon and number after the
> the name such as
> create procedure sp_procedure_pa rams_rowset;2
> what does this do?
>[/color]