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.
V0169:
The specification states the following:
-
Subclause 6.4, "<value specification> and <target specification>": <general value specification> ::= <host parameter specification> | <SQL parameter reference> | <dynamic parameter specification> | <embedded variable specification> | <current collation specification> | CURRENT_CATALOG | CURRENT_DEFAULT_TRANSFORM_GROUP | CURRENT_PATH | CURRENT_ROLE | CURRENT_SCHEMA | CURRENT_TRANSFORM_GROUP_FOR_TYPE <path-resolved user-defined type name> | CURRENT_USER | SESSION_USER | SYSTEM_USER | USER | VALUE ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", conforming SQL language shall not contain a <general value specification> that contains CURRENT_PATH. Subclause 10.3, "<path specification>": <path specification> ::= PATH <schema name list> ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", conforming SQL language shall not contain a <path specification>. Subclause 11.1, "<schema definition>": <schema path specification> ::= <path specification> ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", conforming SQL language shall not contain a <schema path specification>. Subclause 11.5, "<default clause>": <default option> ::= <literal> | <datetime value function> | USER | CURRENT_USER | CURRENT_ROLE | SESSION_USER | SYSTEM_USER | CURRENT_CATALOG | CURRENT_SCHEMA | CURRENT_PATH | <implicitly typed value specification> ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", conforming SQL language shall not contain a <default option> that contains CURRENT_PATH. Subclause 13.1, "<SQL-client module definition>": <module path specification> ::= <path specification> ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", conforming SQL language shall not contain a <module path specification>. Subclause 19.8, "<set path statement>": <set path statement> ::= SET <SQL-path characteristic> <SQL-path characteristic> ::= PATH <value specification> ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", Conforming SQL language shall not contain a <set path statement>. Subclause 21.1, "<embedded SQL host program>": <embedded path specification> ::= <path specification> ... Conformance Rules Without Feature S071, "SQL paths in function and type name resolution", conforming SQL language shall not contain an <embedded path specification>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.