Sample Header Ad - 728x90

Numbered stored procedures: introduction and deprecation?

4 votes
2 answers
1318 views
SQL Server and Sybase ASE both support the highly dubious feature of grouping stored procedures by appending a number: CREATE PROCEDURE Foo;1 AS ... CREATE PROCEDURE Foo;2 AS ... The only tangible benefit is that DROP PROCEDURE Foo will drop all of these procedures together -- and that's it; to call them you still need to append the number explicitly. The drawbacks of allowing a semicolon to be part of a procedure name and having non-obvious DROP semantics should be obvious, and indeed many tools don't (properly) support this format and things like contained databases outright forbid them. In what version of SQL Server and/or Sybase ASE was this feature introduced, and from what version onwards was it deprecated? I'd consult the documentation, but documentation that goes back far enough does not appear to be available. I've found the following: * [SQL Server Books Online 2005](https://www.microsoft.com/download/details.aspx?id=4152) already mentions them as deprecated. * [SyBooks Online for ASE 12.5](http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36272_1251/html/commands/X52197.htm) mentions it as being available there as well, but having a flag to disallow them. This leads me to think the feature might have existed in very early versions indeed, possibly before the split between Sybase and Microsoft, but still doesn't tell me what the earliest introduction and deprecation was. The asteroid to kill this dinosaur is still in orbit, but how old is the dinosaur?
Asked by Jeroen Mostert (183 rep)
Apr 24, 2018, 10:59 AM
Last activity: Jul 21, 2020, 11:54 PM