T-SQL Analyzer

# SQL Server Rule: SRD0050 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidStaticPredicateCompareRule | ## Rule Information | | | |----|----| | Id | SRD0050 | | Friendly Name | Expression reducible to constaint | | Category | Design | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | | | View | ## Description The comparison expression always evaluates to TRUE or FALSE. ## Summary The comparison expression always evaluates to TRUE or FALSE ### Examples Catches: ```sql FROM a JOIN b ON a.id = b.a_id AND 4 < 3 + 2 ``` equivalent to ```sql FROM a JOIN b ON a.id = b.a_id /* true */ ``` ### Remarks Checks join and where clause predicates for predicates that will always evaluate to true/false. _{^{Generated by a tool}}