SQL Colors and Formatting

• ronsqldangerous

  SSC Enthusiast

  Points: 176

  More actions

  December 17, 2020 at 2:17 pm

  #3821616

  Hello,

  I am using the latest version of SSMS.

  I want to make it so that my variables, (Anything that starts with @) comes up a different color. Is there any way to do that?

  Thank You.

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  December 17, 2020 at 4:50 pm

  #3821665

  SSMS does not seem to have any specific category for variables. I don't know if a third-party product like Red Gate's SQL Prompt may offer this.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

• ratbak

  Default port

  Points: 1407

  More actions

  December 17, 2020 at 4:50 pm

  #3821666

  I don't know of a built-in way, nor an addin, that supports that. Seems like a useful option.

  Here's an azure feedback suggestion you can vote on: https://feedback.azure.com/forums/908035-sql-server/suggestions/42237427-add-parameters-and-variables-to-configurable-fonts

• May 13, 2021 at 8:56 am

  This was removed by the editor as SPAM