CR0001: TOP (100) PERCENT

By Blog Author
#analysis-rules #shared-analysis-rules

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

 

[av_promobox button=‘yes’ label=‘Download’ link=‘manually,https://sqlenlight.com/downloads/cr0001.zip’ link_target=” color=‘theme-color’ custom_bg=‘#444444’ custom_font=‘#ffffff’ size=‘large’ icon_select=‘yes’ icon=‘ue82d’ font=‘entypo-fontello’ box_color=” box_custom_font=‘#ffffff’ box_custom_bg=‘#444444’ box_custom_border=‘#333333’ av_uid=‘av-bj75k’] Download and try the CR0001 analysis rule. [/av_promobox]

Back to Blog