Skip to content

SRD0025.md

Latest commit

 

History

History
31 lines (21 loc) · 768 Bytes

SRD0025.md

File metadata and controls

31 lines (21 loc) · 768 Bytes

SQL Server Rule: SRD0025
Assembly SqlServer.Rules.dll
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.