Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Intellisence in SQLCMD mode

On our severs we have large number of databases with same structure and use SQLCMD variables for databaseand shema name in our scripts. Example select t1.* from $(databasename).$(shemaname).TABLE1 t1. It would be very usefull to have intellisence enabled if I type "t1."

14 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Denis shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Rob Orchiston commented  ·   ·  Report

    This functionality totally doesn't work in 2025. I would expect SQL Complete to interpet any SETVAR statements and for Intellisense to work for USE $(MyDBName) or as in the example above. Otherwise I have to override my sqlcmd statements with hard coded values just so I can get value from SQLComplete.