SQL SERVER MANAGEMENT STUDIO: Highlight variables

ssms, t-sql

Solution

It might not work in all cases, but I find that using the `F2` button, which on my machine is mapped to 'View.EditLabel'. It allows me to highlight all of one 'type' things like aliases, variable names and others. Not perfect, but fits my purpose.

I still stand by the fact that it might not be perfect, but it does do what the original poster asked. If you want to see what this command is mapped to see the Options windows.

Problem

Is there a way in SQL SERVER MANAGEMENT STUDIO to highlight all usage of variables when we click on a variable name?

Original source

Related problems