Sonar Rule tsql:S4196 not correct

SonarQube
, ,
1

I think the rule tsql:S4196 Output parameters should be assigned is not correct for T-SQL CLR Procedures.
We are using many SQL CLR Procedures. But Sonar rule S4196 is showing errors for output parameters because there is no code for set the SQL Variable in the SQL File. This happens in external (C#)

image
image1158×390 27.6 KB

THX

4

Hello @ArminPrieschl,

Thank you for reporting this.

It is indeed a valid case of OUTPUT usage.
I created a ticket to add this exception to tsql:S4196.

Have a nice day!