Critical

Code Rules in Critical Severity

Category Severity Name Description
Maintainability Critical A primary key should be specified during table creation A primary key should be specified during table creation
Maintainability Critical CASE expressions should end with ELSE clauses CASE expressions should end with ELSE clauses
Bug Critical CASE input expressions should be invariant CASE input expressions should be invariant
Maintainability Critical Conditionally executed code should be denoted by either indentation or BEGIN...END block Conditionally executed code should be denoted by either indentation or BEGIN...END block
Maintainability Critical Conditionals should start on new lines Conditionals should start on new lines
Maintainability Critical Control flow statements IF, WHILE and TRY should not be nested too deeply Control flow statements IF, WHILE and TRY should not be nested too deeply
Maintainability Critical Control structures should use BEGIN...END blocks Control structures should use BEGIN...END blocks
Bug Critical DELETE and UPDATE statements should contain WHERE clauses DELETE and UPDATE statements should contain WHERE clauses
SecurityWarning Critical Dynamically executing code is security-sensitive Dynamically executing code is security-sensitive
Maintainability Critical Expressions should not be too complex Expressions should not be too complex
Maintainability Critical IF ... ELSEIF constructs should end with ELSE clauses IF ... ELSEIF constructs should end with ELSE clauses
Maintainability Critical INSERT statements should explicitly list the columns to be set INSERT statements should explicitly list the columns to be set
Maintainability Critical NOCOUNT should be activated on PROCEDURE and TRIGGER definitions NOCOUNT should be activated on PROCEDURE and TRIGGER definitions
Bug Critical Nullable subqueries should not be used in NOT IN conditions Nullable subqueries should not be used in NOT IN conditions
Maintainability Critical SELECT statements used as argument of EXISTS statements should be selective SELECT statements used as argument of EXISTS statements should be selective
Vulnerability Critical SHA-1 and Message-Digest hash algorithms should not be used in secure contexts SHA-1 and Message-Digest hash algorithms should not be used in secure contexts
Maintainability Critical Size should be specified for varchar variables and parameters Size should be specified for varchar variables and parameters
Maintainability Critical String literals should not be duplicated String literals should not be duplicated
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