2.1.1.35 T321-02, User-defined stored procedures with no overloading

  • Article

V0035:

The specification states the following:

 Subclause 11.60, "<SQL-invoked routine>": With <SQL-invoked procedure>
  
 <SQL-invoked routine> ::=
 <schema routine>
  
 <schema routine> ::=
 <schema procedure>
 | <schema function>
  
 <schema procedure> ::=
 CREATE <SQL-invoked procedure>
  
 <schema function> ::=
 CREATE <SQL-invoked function>
  
 <SQL-invoked procedure> ::=
 PROCEDURE <schema qualified routine name> <SQL parameter declaration list>
 <routine characteristics>
 <routine body>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature.