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.
V0210:
The specification states the following:
-
Subclause 5.3, "<literal>": <binary string literal> ::= X <quote> [ <space>... ] [ { <hexit> [ <space>... ] <hexit> [ <space>... ] }... ] <quote> [ { <separator> <quote> [ <space>... ] [ { <hexit> [ <space>... ] <hexit> [ <space>... ] }... ] <quote> }... ] <hexit> ::= <digit> | A | B | C | D | E | F | a | b | c | d | e | f ... Conformance Rules Without Feature T023, "Compound binary literals", in conforming SQL language, a <binary string literal> shall contain exactly one repetition of "<quote> [ { <hexit> <hexit> }... ] <quote>".
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.