CAST Rules

46 Rules

ID	Name	Severity
1634	Avoid unreferenced Tables	medium
4056	Avoid recursive Triggers	medium
4062	Avoid Functions and Procedures doing an Insert, Update or Delete without managing a transaction	medium
4064	Avoid Procedures using an Insert, Update, Delete, Create Table or Select without including error management	high
4066	Avoid Stored Procedures not returning a status value	medium
4070	Avoid use of "truncate table"	high
4076	Avoid using temporary Objects	medium
4084	Avoid nested Stored Procedures using temporary Tables	medium
7386	Avoid Tables without a clustered Index	medium
7404	Avoid unreferenced views	medium
7420	Avoid SQL queries with implicit conversions in the WHERE clause	medium
7660	Never use SQL queries with a cartesian product on XXL Tables	high
7662	Avoid SQL queries on XXL Tables with implicit conversions in the WHERE clause	high
7760	Avoid triggers, functions and procedures with a very low comment/code ratio	medium
7762	Avoid undocumented Triggers, Functions and Procedures	medium
7766	Avoid Artifacts with High Cyclomatic Complexity	medium
7768	Avoid Artifacts with High Depth of Code	medium
7770	Avoid Artifacts with too many parameters	medium
7772	Avoid Artifacts with High Essential Complexity	medium
7774	Avoid Artifacts with High Integration Complexity	medium
7776	Avoid Artifacts with High Fan-In	medium
7778	Avoid Artifacts with High Fan-Out	medium
7784	Avoid Artifacts with lines longer than X characters	medium
7786	Avoid long Table or View names	medium
7790	Avoid Cursors inside a loop	critical
7806	Avoid Artifacts with Group By	medium
7808	Avoid Artifacts with SQL statement including subqueries	medium
7810	Avoid Artifacts with a Complex SELECT Clause	medium
7814	Avoid Tables not using referential integrity	medium
7816	Avoid using GOTO statement	medium
7820	Never use SQL queries with a cartesian product	medium
7822	Avoid Artifacts with queries on more than 4 Tables	medium
7828	Avoid Artifacts with High RAW SQL Complexity	medium
7840	Trigger naming convention - prefix control	medium
7842	Avoid large Artifacts - too many Lines of Code	medium
7852	Database view naming convention - prefix control	medium
7854	Database table naming convention - prefix control	medium
7856	Avoid Tables with too many columns on an OLTP system	medium
7860	Avoid unreferenced Functions and Procedures	medium
7898	SQL Function naming convention - prefix control	medium
7900	Stored Procedure naming convention - prefix control	medium
7902	Avoid SQL queries that no index can support	medium
7904	Avoid SQL queries on XXL tables that no index can support	high
7946	Avoid queries using old style join convention instead of ANSI-Standard joins	medium
8080	Avoid exists independent clauses	high
8082	Avoid Tables without Primary Key	high

46 Rules

Sign In