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

2 comments

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
  • Dan Jary

    Hi henrik_ffc 

    My apology for the delay in updating you on this.

    Just to make you aware that our development team are continuing to engage with Microsoft on this. Essentially, they do not support the syntax for "IS [NOT] DISTINCT FROM," which is causing a parse error in SQL Prompt.

    I will update you again as soon as a fix has been implemented for this by Microsoft.

    Dan Jary
    1

Add comment

Please sign in to leave a comment.