2.1.2.241 T522, Default values for IN parameters of SQL-invoked procedures

V0277:

The specification states the following:

 Subclause 6.5, "<contextually typed value specification>":
  
 <contextually typed value specification> ::=
 <implicitly typed value specification>
 | <default specification>
  
 Subclause 10.4, "<routine invocation>":
  
 <SQL argument> ::=
 <value expression>
 | <generalized expression>
 | <target specification>
 | <contextually typed value specification>
 | <named argument specification>
  
 ...
  
 Conformance Rules:
  
 Without Feature T522, "Default values for IN parameters of SQL-invoked procedures", in conforming SQL language an <SQL argument> shall not be a <contextually typed value specification>.
  
 Subclause 11.60, "<SQL-invoked routine>":
  
 <parameter default> ::=
 <value expression>
 | <contextually typed value specification>
  
 ...
  
 Conformance Rules:
  
 Without Feature T522, "Default values for IN parameters of SQL-invoked procedures", conforming SQL language shall not contain a <parameter default>.

Microsoft SQL Server 2008 R2 varies as follows:

This feature is absent from the [ISO/IEC9075-2:2008] standard.

Microsoft SQL Server 2012 varies as follows:

Transact-SQL partially supports this feature. The syntax differs from the standard.