Minor

Non-standard comparison operators should not be used

Description

    The rule "Non-standard comparison operators should not be used" states that any comparison operators other than the standard ones provided by SQL Server should not be used. This includes operators such as <, >, =, !=, <>, etc. These operators should only be used for comparing values in the same type, and not for comparing values between different types. This rule is important for ensuring that queries are properly formed and that data is accurately compared.

Key Benefits

  • Clarity: Using standard comparison operators ensures code is easily readable and understandable.
  • Maintainability: Non-standard comparison operators can be confusing and difficult to maintain.
  • Safety: Using standard comparison operators helps to reduce the chances of introducing bugs into the code.

 

Non-compliant Code Example

DECLARE @Number int;  
SET @Number = 50;  
IF @Number !> 10  --Non compliant code (Non-standard comparison operators is used)
    BEGIN
        Select * From Employee Where id < @Number;
        PRINT 'The number is less then 10.';  
    END
ELSE IF @Number !< 100   --Non compliant code (Non-standard comparison operators is used)
    BEGIN
        Select * From Employee Where id < @Number;
        PRINT 'The number is greater then 100.';  
    END
ELSE  
    PRINT 'The number is medium.'; 
GO

Compliant Code Example

DECLARE @Number int;  
SET @Number = 50;  
IF @Number < 10  --Compliant code (Standard comparison operators is used)
    BEGIN
        Select * From Employee Where id < @Number;
        PRINT 'The number is less then 10.';  
    END
ELSE IF @Number > 100   --Compliant code (Standard comparison operators is used)
    BEGIN
        Select * From Employee Where id < @Number;
        PRINT 'The number is greater then 100.';  
    END
ELSE  
    PRINT 'The number is medium.'; 
GO
Visual Expert 2023
 VETSQLRULE78