ssms
In visual studio I find it very helpful to find where a variable is being used by highlighting it and all occurrences of that var will appear highlighted as well.
Is there a way to enable this feature in Sql Server Management studio 2014 while viewing scripts?
Text highlighting is mentioned here.
Thanks!
In SSMS
Default is "false"...
Variable colors share settings with table, object and other names. So you can change the text color using Identifier:
Just note that it will also affect table names, column names etc.
For the highlighted color of identifiers and variables, use Selected Text. The highlights will use a slightly muted version of that color.
And no, these are not my current settings, and I only kept them that way long enough to grab a screen shot...
Best Answer
SQL Server Management Studio (SSMS) 2016 has this feature. There is no real reason to user the older versions now as it's supposed to be backwards compatible, although there may be a bug or two (see below).
Just press Ctrl+ F to see your keywords highlighted like this:
Maybe a few bugs for SSMS 2016 on connect ...