Home
Lines should not be too long
Rule description
- Lines should not be too long
Non-compliant Code Example
SELECT ProductID, ProductName, ProductCategory, Price, InStockQuantity, AVG(OrderQty) AS AverageQuantity, SUM(LineTotal) AS Total --Non compliant code (Line length is more then default defined limit 100)
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING SUM(LineTotal) > 3000.00
AND AVG(OrderQty) < 3;
Compliant Code Example
SELECT ProductID, ProductName, --Compliant code (Line length is less then default defined limit 100)
ProductCategory,
Price,
InStockQuantity,
AVG(OrderQty) AS AverageQuantity,
SUM(LineTotal) AS Total
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING SUM(LineTotal) > 3000.00
AND AVG(OrderQty) < 3;