'\''' breaks syntax highlighting. The following is valid TSQL code to escape single quotes in a string:
SELECT REPLACE('hello '' world', '''', '\''')
Expected output: hello \' world
I believe the problem is that the highlighter treats \ as an escape character, while TSQL does not. The highlighter sees the first 4 characters as a string containing a single escaped quote '\'', and the last single quote as the start of a new string, where TSQL sees it as a string with a backslash and a single quote.
'\'''
breaks syntax highlighting. The following is valid TSQL code to escape single quotes in a string:SELECT REPLACE('hello '' world', '''', '\''')
Expected output:
hello \' world
I believe the problem is that the highlighter treats \ as an escape character, while TSQL does not. The highlighter sees the first 4 characters as a string containing a single escaped quote
'\''
, and the last single quote as the start of a new string, where TSQL sees it as a string with a backslash and a single quote.