T-SQL Analyzer

# SQL Server Rule: SRD0025 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidNumericOrderByRule | ## Rule Information | | | |----|----| | Id | SRD0025 | | Friendly Name | Avoid ORDER BY with numbers | | Category | Design | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | ## Description Avoid using column numbers in ORDER BY clause. ## Summary Avoid the use of column numbers in a where clause. If someone changes the select query without updating the column number, then the sorting could inadvertently change. _{^{Generated by a tool}}