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

  • Article

V0037:

The specification states the following:

 Subclause 5.37, "PARAMETERS view":
  
 Without Feature T522, "Default values for IN parameters of SQL-invoked procedures", conforming SQL language shall not reference INFORMATION_SCHEMA.PARAMETERS.PARAMETER_DEFAULT.
  
 Function
  
 Identify the SQL parameters of SQL-invoked routines defined in this catalog that are accessible to a given user or role.
  
  
 Subclause 5.81, "Short name views":
  
 Without Feature T522, "Default values for IN parameters of SQL-invoked procedures", conforming SQL language shall not reference INFORMATION_SCHEMA.PARAMETERS_S.PARAMETER_DEFAULT.
  
 Function
  
 Provide alternative views that use only identifiers that do not require Feature F391, "Long identifiers".
 

Microsoft SQL Server 2008 R2 varies as follows:

This feature is absent in the [ISO/IEC9075-11:2008] specification.

Microsoft SQL Server 2012 varies as follows:

Transact-SQL does not support this feature.