T321-01, User-defined functions with no overloading


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.