2.1.2.115 F847, Nonconstant regular expressions

V0151:

The specification states the following:

 Subclause 6.4, "<value specification> and <target specification>":
  
 <value specification> ::=
 <literal>
 | <general value 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
  
 Subclause 6.28, "<numeric value function>":
  
 <XQuery pattern> ::=
 <character value expression>
  
 <XQuery option flag> ::=
 <character value expression>
  
 ...
  
 Conformance Rules
  
 Without Feature F847, "Nonconstant regular expression", in conforming SQL language, <XQuery pattern> and <XQuery option flag> shall be <value specification>s.
  
 Subclause 6.30, "<string value function>":
  
 <XQuery replacement string> ::=
 <character value expression>
  
 ...
  
 Conformance Rules
  
 Without Feature F847, "Nonconstant regular expressions", in conforming SQL language, <XQuery pattern>, <XQuery option flag>, and <XQuery replacement string> shall be <value specification>s.
  
 Subclause 8.7, "<regex like predicate>":
  
 <regex like predicate> ::=
 <row value predicand> <regex like predicate part 2>
  
 <regex like predicate part 2> ::=
 [ NOT ] LIKE_REGEX <XQuery pattern> [ FLAG <XQuery option flag> ]
  
 ...
  
 Conformance Rules
  
 Without Feature F847, "Nonconstant regular expressions", in conforming SQL language, <XQuery pattern> and <XQuery option flag> shall be <value specification>s.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.