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

Variables are never used

Hi Redgate Team,

The code analysis reports that the variables are never used but obviously it is not the case.

DECLARE
    @inaccessible   nvarchar(12),
    @invalidlogin   nvarchar(12),
    @dbinaccessible nvarchar(12);
SELECT @inaccessible = LTRIM(STR(CONVERT(int, 0x03e0), 11));
SELECT @invalidlogin = LTRIM(STR(CONVERT(int, 0x40000000), 11));
SELECT @dbinaccessible = N'0x80000000'; /* SQLDMODbUserProf_InaccessibleDb; the negative number doesn't work in convert() */

I am using the latest version of SQL Prompt.

Thanks for looking into this.

Torsten

torsten.strauss
0

Comments

1 comment

Sort by
  • Russell D
    Hi Torsten,

    The Prompt team has confirmed that in the example you reported, the variable is declared and assigned, but it is never "consumed"/"read". They appreciate it would be a good idea to split it into 2 rules:
    1- Variable declared but not used.
    2- Variable assigned but not used.

    However, at the moment they are not planning to make this change in the near future due to other concerns. We still have it logged in our system as SP-6765  though and we'll reassess it again in the future.
    Russell D
    0

Add comment

Please sign in to leave a comment.