SEO

#1 (**permalink**) 02-29-2008, 07:50 AM

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?

#2 (**permalink**) 02-29-2008, 07:50 AM

This is a versioning mechanism, see BOL CREAT E PROCEDURE

http://msdn.microsoft.com/library/de...reate_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.googlegro ups.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?
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

What is purpose of semi colon after procedure name