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;