Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Syntax coloration failure in a T-SQL file with .sql extension

    General Discussion
    1
    1
    868
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Martin Spence
      Martin Spence last edited by

      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

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Copyright © 2014 NodeBB Forums | Contributors