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.
V0195:
The specification states the following:
-
Subclause 11.65, "<user-defined ordering definition>": <user-defined ordering definition> ::= CREATE ORDERING FOR <schema-resolved user-defined type name> <ordering form> ... Conformance Rules Without Feature S251, "User-defined orderings", conforming SQL shall not contain a <user-defined ordering definition>. NOTE — If MAP is specified, then the Conformance Rules of Subclause 9.11, "Equality operations", apply. If ORDER FULL BY MAP is specified, then the Conformance Rules of Subclause 9.14, "Ordering operations", also apply. Subclause 9.11, "Equality operations": Conformance Rules Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared type of an operand of an equality operation shall not be ST-ordered. Without Feature T042, "Extended LOB data type support", in conforming SQL language, the declared type of an operand of an equality operation shall not be LOB-ordered. Without Feature S275, "Advanced multiset support", in conforming SQL language, the declared type of an operand of an equality operation shall not be multiset-ordered. NOTE — If the declared type of an operand OP of an equality operation is a multiset type, then OP is a multiset operand of a multiset element grouping operation. The Conformance Rules of Subclause 9.13, "Multiset element grouping operations", apply. Subclause 9.13, "Multiset element grouping operations": Conformance Rules Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared element type of a multiset operand of a multiset element grouping operation shall not be ST-ordered. Subclause 9.14, "Ordering operations": Conformance Rules Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared type of an operand of an ordering operation shall not be ST-ordered. Subclause 11.66, "<drop user-defined ordering statement>": <drop user-defined ordering statement> ::= DROP ORDERING FOR <schema-resolved user-defined type name> <drop behavior> ... Conformance Rules Without Feature S251, "User-defined orderings", conforming SQL language shall not contain a <drop user-defined ordering statement>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.