T-SQL Analyzer

Parser:

SET QUOTED_IDENTIFIER:

Analysis:

 Select the rules which to be used during T-SQL script analysis.

All rules
SA0001 : Equality and inequality comparisons involving a NULL constant
SA0002 : Variable @variable declared but never used.
SA0003 : Variable @variable used but not previously assigned.
SA0004 : Variable @variable assigned but value never used.
SA0005 : Non-ANSI outer join syntax.
SA0006 : Non-ANSI inner join syntax.
SA0007 : Pattern starting with "%" in LIKE predicate.
SA0008 : Deprecated syntax 'string_alias' = expression.
SA0010 : Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
SA0011 : SELECT * in stored procedures, views and table valued functions.
SA0012 : Use SCOPE_IDENTITY() instead @@IDENTITY.
SA0013 : Avoid returning results in triggers.
SA0014 : Avoid 'fn_' prefix when naming functions.
SA0015 : Avoid 'sp_' prefix when naming stored procedures.
SA0016 : Use of very small variable length type (size 1 or 2).
SA0017 : SET NOCOUNT ON option in stored procedures and triggers.
SA0018 : Support for constants in ORDER BY clause have been deprecated.
SA0019 : TOP clause used in a query without an ORDER BY clause.
SA0020 : Always use a column list in INSERT statements.
SA0021 : Deprecated usage of table hints without WITH keyword.
SA0022 : Index type (CLUSTERED or NONCLUSTERED) not specified.
SA0023 : Avoid using inequality operators (<>,!=) in the WHERE clause.
SA0024 : Local cursor not closed.
SA0025 : Local cursor not explicitly deallocated.
SA0026 : Local cursor reference not explicitly deallocated.
SA0027 : Avoid wrapping filtering columns within a function in the WHERE clause.
SA0028 : Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
SA0029 : Input parameter never used.
SA0030 : Output parameter never assigned.
SA0032 : Avoid using NOT IN predicate in the WHERE clause.
SA0033 : Don't use the GROUP BY clause without an aggregate function.
SA0031 : Avoid using GOTO statement to improve readability.
SA0034 : Consider using parentheses to improve readability and avoid mistakes because of logical operator precedence.
SA0035 : TODO,HACK or UNDONE phrase found in a comment. It probably indicates a task that needs to be completed.
SA0036 : DELETE statement without WHERE clause.
SA0037 : UPDATE statement without WHERE clause.
SA0038 : The WHERE clause contains comparison which evaluates to TRUE.
SA0039 : The WHERE clause contains comparison which evaluates to FALSE.
SA0042 : Avoid using special characters in object names.
SA0043 : Avoid using reserved words for type names.
SA0051 : Possible result of Cartesian product due to incomplete table joins.
SA0052 : Avoid using undocumented and deprecated stored procedures.
SA0054 : Avoid modification of parameters in a stored procedure prior to use in a query.

select all

Analyze Reformat Go To Beautifier Settings

Analysis Results

---