Posted by Gert E.R. Drapers on 06/05/05 11:30

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.Net

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@g49g2000cwa.googlegroups.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_params_rowset;2
> what does this do?
>

[Back to original message]