Home

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;