[thelist] MSSQL proc naming (was re: Comma delimited string inSQL)

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "rudy" <rudy937 at rogers.com>
Subject: Re: [thelist] MSSQL proc naming (was re: Comma delimited string
inSQL)


: > > but do not name your procedure starting with sp_
: >
: > Not sure whether rudy's saying this for this reason,
: > or whether he just doesn't like using prefixes (or both)...
:
: both
:
: can you execute anything else besides a stored procedure?
:
: it's the same with table names, i don't prefix them with
: "tbl" either
:
: as joe celko said -- nounParis prepIn artThe nounSpring
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

That said:

a) You can EXEC[UTE] a string
b) MS SQL Server already comes with all sprocs prepended with sp_ (or dt_ if
you have Visual Studio & SP source control). If, like me, you like to be
able to keep ones own sprocs separate to the supplied sprocs (eg in an
object listing), then you need to prepend your own sprocs with something
uniform, eg usp_

Cheers
Ken

Microsoft MVP - Windows Server (IIS)