CR0001: TOP (100) PERCENT
Message
TOP (100) PERCENT found
Description
This rule checks for the phrase “TOP (100) PERCENT”.
This phrase has no bearing unless the percentage is less than 100.
This phrase is commonly generated by creating a view in the SQL Server View Designer.
Author
Jeff Foushee
Example
SELECT TOP 100 PERCENT
LastName, FirstName, JobTitle, Department
FROM HumanResources.vEmployeeDepartment
ORDER BY LastName ASC
Leave a Reply
Want to join the discussion?Feel free to contribute!