Bug
Code Rules in Bug category
Category | Severity | Name | Description |
---|---|---|---|
|
|
|
All branches in a conditional structure should not have exactly the same implementation |
|
|
|
CASE input expressions should be invariant |
|
|
|
DELETE and UPDATE statements should contain WHERE clauses |
|
|
|
Identical expressions should not be used on both sides of a binary operator |
|
|
|
Jump statements should not be followed by dead code |
|
|
|
Loops with at most one iteration should be refactored |
|
|
|
NULL should not be compared directly |
|
|
|
Nullable subqueries should not be used in NOT IN conditions |
|
|
|
Output parameters should be assigned |
|
|
|
Queries that use TOP should have an ORDER BY |
|
|
|
Related IF/ELSE IF statements and WHEN clauses in a CASE should not have the same condition |
|
|
|
Syntax Errors |
|
|
|
The number of variables in a FETCH statement should match the number of columns in the cursor |
|
|
|
Unary prefix operators should not be repeated |
|
|
|
Variables should not be self-assigned |
|
|
|
WHERE clause conditions should not be contradictory |
|
|
|
WHERE clauses should not contain redundant conditions |