2.1.1.34 T321-01, User-defined functions with no overloading

Article
02/14/2019
2 minutes to read

V0034:

The specification states the following:

 Subclause 11.60, "<SQL-invoked routine>": With <function specification>
  
 <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 function> ::=
 { <function specification> | <method specification designator> } <routine body>
  
 ...
  
 <function specification> ::=
 FUNCTION <schema qualified routine name> <SQL parameter declaration list>
 <returns clause>
 <routine characteristics>
 [ <dispatch clause> ]

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

Transact-SQL partially supports this feature.