How can we help you today? How can we help you today?

Where did my @Variables go?

Hi,

I'm busy with a rather sizable sql script. To my dismay SQL Prompt does not list any of my declared @variables anymore. Why is this? Can it be fixed?

Thank you,

JP
JPM
0

Comments

2 comments

Sort by
  • JPM
    Hi,

    Nevermind, I got it working.

    My script contained some errors. I simply parsed the script in the Management Studio, fixed the errors, and code completion worked perfectly again.
    JPM
    0
  • Bart Read
    Hi JP,


    Glad you got it sorted out. Syntax errors can completely screw everything up because the parser isn't always able to recover from them in a useful fashion. You can however highlight errors using SQL Refactor, although you need to do something like layout the script to get it to do this since it won't do it automatically.


    HTH,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.