Code Analysis VS "IS DISTINCT FROM"
henrik_ffc
Posts: 11 Bronze 2
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
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
Tagged:
Best Answer
-
Dan_J
Posts: 460 Silver 2
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.
