Home

ANSI_NULLS, ANSI_PADDING and CONCAT_NULL_YIELDS_NULL should not be configured

  • Maintainability
  • Major

Rule description

  • ANSI_NULLS, ANSI_PADDING and CONCAT_NULL_YIELDS_NULL should not be configured

 

Non-compliant Code Example 

SET ANSI_NULLS OFF  --Non compliant code
Go
SET ANSI_PADDING OFF  --Non compliant code
GO
SET CONCAT_NULL_YIELDS_NULL OFF  --Non compliant code
GO
Visual Expert 2020
 VETSQLRULE25