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

Code Analysis VS "IS DISTINCT FROM"

using "IS DISTINCT FROM" in a proc, disables code analysis :-(
Where is the green underline under @unused in proc test2 / line #17?
SSMS 20.2 / SQL Prompt 10.14.21.9884  / Default Code analysis rules

UPDATE: Just realised that this also breaks the intellisense and it is a rather old and known issue,
still not fixed: SQLServer2022 - IS [NOT] DISTINCT FROM breaks intellisense — Redgate forums


henrik_ffc
0

Comments

1 comment

Sort by
  • Dan_J
    Hi @henrik_ffc

    Thanks for reaching out to us regarding this.

    We have been looking over what you have provided and do think there is something not quite right with Code Analysis here. We're engaging with our development team on this and will come back to you again if we have any questions, or when there is an update.
    Dan_J
    0

Add comment

Please sign in to leave a comment.