Code Analysis:DataType Mismatch Detection
sfrigard
Posts: 5 Bronze 2
in SQL Prompt
I was wondering if Code Analysis is capable to detecting implicit conversion issues.
I have inherited a database where a lot of the stored procedures have various types of data type mismatch issue resulting in implicit conversion. Having a report that would identify this would be very helpful when I am editing a stored procedure.
I have inherited a database where a lot of the stored procedures have various types of data type mismatch issue resulting in implicit conversion. Having a report that would identify this would be very helpful when I am editing a stored procedure.
Tagged:
Answers
It sounds like this rule is what you are looking for - https://documentation.red-gate.com/codeanalysis/execution-rules/ei001.
Kind regards,
Alex
Have you visited our Help Center?