Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Format SQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Option to highlight parenthesis matches

In order for the braces/parenthesis highlighting to work currently, you must run the native Intellisense feature in SSMS, which creates some issues with SQL Prompt. If this were written in as part SQL Prompt, we'd be able to turn off Intellisense completely.

51 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Jason Hannas shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • BlueCollarCritic commented  ·   ·  Report

    IDM Comps Ultra Edit & Ultra Studio text editors support parenthesis matching or pairing and this has been an incredible time saver for me when debugging large, convoluted and deeply nested code.

  • Paul White commented  ·   ·  Report

    Also true in SSMS 2012 with SQL Prompt 5.3.2.2

    Disabled native IntelliSense = no pair matching (parentheses or BEGIN syntaxes)

  • Jason Hannas commented  ·   ·  Report

    I use SSMS 2008 (10.0.4000.0) -- verified again a few minutes ago. SQL Prompt 5.2.0.5.

  • Stephen Anslow commented  ·   ·  Report

    I'm using 2008R2 tools against a 2005 instance and there's no matching for:

    SELECT * FROM ( SELECT 1 AS One ) AS s

    When keying the closing paren, it's not bolded immediately after being keyed. When moving the cursor over either open or close paren, nothing changes.

    It's very RARE for parenthesis matching to work, as in, counted on on hand over the last year of constant use of SQL Prompt.

  • Justin Caldicott commented  ·   ·  Report

    In which version of SSMS is this a problem? I just tried turning off SSMS intellisense in SSMS 2008 and I still get parenthesis highlighting.