Options
Where did my @Variables go?
JPM
Posts: 8 Bronze 2
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
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
Comments
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.
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
Principal Consultant
bartread.com Ltd