Where did my @Variables go?

JPM

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

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.

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