Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 792 Bytes

SRP0016.md

File metadata and controls

32 lines (22 loc) · 792 Bytes

SQL Server Rule: SRP0016

Assembly SqlServer.Rules.dll
Namespace SqlServer.Rules.Performance
Class DataTypesOnBothSidesOfEqualityRule

Rule Information

Id SRP0016
Friendly Name Equality test with mismatched types
Category Performance
Ignorable false
Applicable Types Procedure
Scalar Function
Table Valued Function
View

Description

Data types on both sides of an equality check should be the same in the where clause. (Sargable)

Summary

Data types on both sides of an equality check should be the same in the where clause. (Sargeable)