Visual Expert Rules

Bug

Code Rules in Bug category

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