Syntax coloration failure in a T-SQL file with .sql extension
-
A single backslash at the end of a T-SQL string literal, delimited with single quotes as usual in that language, causes subsequent syntax coloration in the file to fail.
Example:– TEST.SQL
DECLARE @FOO VARCHAR(10) = ‘’ – Syntax coloration fails after backslash before closing single quote, which is valid in T-SQL. Backslash does not indicate an escaped character.
– Syntax coloration fails because algorithm thinks a string literal is still open.
DECLARE @FI INT = 0