Home

Column references should not have more than two-parts

Rule description

  • Column references should not have more than two-parts

 

Non-compliant Code Example

SELECT Production.Product.ProductID,   --Non compliant code (Column reference has more than two parts)
Production.Product.Name,  --Non compliant code (Column reference has more than two parts)
Product.Color  
FROM Production.Product  
ORDER BY ListPrice;

Compliant Code Example

SELECT Product.ProductID,   --Compliant code (Column reference has two or less parts)
Product.Name,
Color  
FROM Production.Product  
ORDER BY ListPrice;
Visual Expert 2020
 VETSQLRULE46