Equals sign after variable names in a SET statement

robw

Is there a way to make an = appear automatically after I type a variable name right after a SET statement? A more general question would be "Is there a way to modify or extend the intellisense capabilities of SQL Prompt"?

Brian Donahue

Hi Rob,
I don't see an option in the SQL Prompt settings to auto-complete an equals sign for variable assignments. I think that what you may be after is some sort of "grammar" file, but SQL Prompt doesn't give you the ability to extend it in this way. I'd agree that approach would be useful, especially when changes are introduced in the T-SQL syntax as well.