Inspectopedia Help

SQL

Name

Language

Adding not null column without default value  

SQL

Aggregate-related problems  

SQL

Ambiguous reference  

SQL

Auto-increment duplicate  

SQL

Check using clause columns  

SQL

Column is shadowed by alias  

SQL

Column should be in group by clause  

SQL

Constant condition  

SQL

Constant expression  

SQL

Current console schema introspected  

SQL

Delete or update statement without where clauses  New in this release

SQL

Deprecated type  

SQL

Duplicating column name in SELECT  

SQL

Each derived table should have alias  

SQL

Function signature  

SQL

Identifier should be quoted  

SQL

Ill-formed date/time literals  

Sqldatetime

Illegal cursor state  

SQL

Implicit string truncation  

SQL

Index is dependent on column  

SQL

Insert NULL into NOT NULL column  

SQL

Insertion into generated columns  

SQL

Misleading references  

SQL

Missing column aliases  

SQL

Missing return statement  

SQL

Multiple row limiting/offset clauses in queries  

SQL

Named arguments should be used  

SQL

No data sources configured  

SQL

Null comparison  

SQL

Redundant ELSE NULL clause  

SQL

Redundant alias expressions  

SQL

Redundant code in COALESCE call  

SQL

Redundant ordering direction  

SQL

Redundant row limiting in queries  

SQL

SQL dialect detection  

SQL

SQL source modification detection  

SQL

Statement with side effects  

SQL

Suspicious code in triggers  

SQL

Types compatibility  

SQL

Unicode usage in SQL  

SQL

Unreachable code  

SQL

Unresolved reference  New in this release

SQL

Unsafe 'join' clause in 'delete' statement  

SQL

Unused common table expression  

SQL

Unused subquery item  

SQL

Unused variable  

SQL

Usages of GOTO statements  New in this release

SQL

Use of transaction management statements in triggers  

SQL

Using CASE instead of COALESCE function and vice versa  New in this release

SQL

Using CASE instead of conditional function and vice versa  New in this release

SQL

Using of named and positional arguments  

SQL

VALUES clause cardinality  

SQL

Last modified: 13 July 2023