Feature Request: Parenthesis highlighting

williamd · May 6, 2010 10:07AM

Hi there,

I would like to suggest a small extra feature for future SQL Prompt releases.

Give the following code:

select top (10) * from dbo.Personnel

When you move the cursor to either of the brackets, the corresponding bracket should be highlighted.

This is a feature within the native intellisense that I really would like to use with SQL Prompt. It is especially helpful with multi-layered bracketing; think CAST(SUM(n) as varchar(5)).

At present I have to disable SQL Prompt, enable Intellisense and then do the work of identifying the different layers and then reverse the procedure to be back in "developer mode".

David Atkinson · May 6, 2010 1:04PM

Thanks for the request. Yes, this would be a great feature to have. I've raised this as an enhancement (SP-2963). We'll let you know if this finds its way into the tool.

Thanks!

David Atkinson
Product Manager
Red Gate Software

MikeyC · May 6, 2010 1:31PM

SQL Prompt sort of has this, as you are typing the ()s it will highlight them. But for existing code you have to select the ( or ) and type over it and it will highlight the matching one. (It is sort of a pain, but it isn't as much of a pain as disabling SQL Prompt, and enabling Intellisense.)

David Atkinson · May 6, 2010 1:37PM

Hmmm... I've just tried this and even with native Statement Completion disabled the parentheses correctly highlight when I move my cursor over it.

David

williamd · May 7, 2010 2:56AM

Hi all,

I am not seeing the same behaviour as you all are.

When I type an opening bracket, the corresponding close bracket is added automatically (this is an optional setting that I have enabled) and going inside a set of brackets brings up the tooltip that corresponds to the command. However, the grayed highlighting is not happening for me, regardless of the method tried - this is not an optional setting is it?

Here is my system setup:

Windows 7 Enterprise Edition 64 Bit (English)
Microsoft SQL Server Management Studio 10.0.2531.0
SQL Prompt Professional Edition 4.0.2.53

Additionally installed tools in SSMS
SSMS Tools Pack 1.7.5.1
SQL Refactor 1.3.0.207

On top of this I have a three monitor setup using an NVIDIA Quadro NVS 450. I have seen rendering problems before due to multi-monitor setups. I don't think this can be the issue it is better to mention it, just in case.

Anu D · May 7, 2010 6:38AM

This is SSMS 2008 feature and in order to use it you need to check your below settings:

1. In SSMS 2008 Tools --> Options --> Text Editor --> Transact-SQL --> make sure to deselect option 'Auto list members'

2. Tools --> Options --> Text Editor --> Transact-SQL --> IntelliSense --> Select option 'Enable Intellisense'

After that open a new window and check if that feature is enabled or not.

Kindly let us know whether this fixes the issue for you.

williamd · May 7, 2010 6:45AM

Hi Anu,

that does activate the highlighting, thank you! However, with the native intellisense active I get the table and column suggestions from both SQL Prompt and Intellisense.

I hope this feature gets baked into SQL Prompt, two tools combined to fulfill a task is not "ingeniously simple"

Thanks to all for the help.

Anu D · May 7, 2010 6:49AM

Have you deslected this option?
In SSMS 2008 Tools --> Options --> Text Editor --> Transact-SQL --> make sure to deselect option 'Auto list members'

If you deselect this option it should not show up native intellisense?

Feature Request: Parenthesis highlighting

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk