Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0166:
The specification states the following:
-
Subclause 6.1, "<data type>": <reference type> ::= REF <left paren> <referenced type> <right paren> [ <scope clause> ] ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <reference type>. Subclause 6.20, "<attribute or method reference>": <attribute or method reference> ::= <value expression primary> <dereference operator> <qualified identifier> [ <SQL argument list> ] ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain an <attribute or method reference>. Subclause 6.21, "<dereference operation>": <dereference operation> ::= <reference value expression> <dereference operator> <attribute name> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <dereference operation>. Subclause 6.26, "<value expression>": <reference value expression> ::= <value expression primary> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <reference value expression>. Subclause 21.3, "<embedded SQL Ada program>": <Ada REF variable> ::= SQL TYPE IS <reference type> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain an <Ada REF variable>. Subclause 21.4, "<embedded SQL C program>": <C REF variable> ::= SQL TYPE IS <reference type> <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] }... ] ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <C REF variable>. Subclause 21.5, "<embedded SQL COBOL program>": <COBOL REF variable> ::= [ USAGE [ IS ] ] SQL TYPE IS <reference type> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <COBOL REF variable>. Subclause 21.6, "<embedded SQL Fortran program>": <Fortran REF variable> ::= SQL TYPE IS <reference type> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <Fortran REF variable>. Subclause 21.7, "<embedded SQL MUMPS program>": <MUMPS REF variable> ::= SQL TYPE IS <reference type> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <MUMPS REF variable>. Subclause 21.8, "<embedded SQL Pascal program>": <Pascal REF variable> ::= SQL TYPE IS <reference type> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <Pascal REF variable>. Subclause 21.9, "<embedded SQL PL/I program>": <PL/I REF variable> ::= SQL TYPE IS <reference type> ... Conformance Rules Without Feature S041, "Basic reference types", conforming SQL language shall not contain a <PL/I REF variable>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.