Home / Vulnerability Database / T-SQL : Incorrect comparison with NULL
T-SQL
T-SQL : Incorrect comparison with NULL
Overview
The application performs incorrect comparison to NULL using =, !=, or <>. In the ANSI SQL standard, the value of NULL is defined as unknown. It is not equal to anything, not even another NULL value. Also, a null value is never not equal to another value. By default, T-SQL complies to the standard, but it can be changed using the SET ANSI_NULLS OFF command. It is recommended to make all T-SQL code ANSI compliant.
LOW
DerScanner Severity Score
Do you want to fix T-SQL : Incorrect comparison with NULL in your application?
See also
T-SQL
T-SQL : Weak encryption algorithm
T-SQL
T-SQL : Weak hashing algorithm
T-SQL