SQL: Don't use numeric constants in T-SQL ORDER BY clauses

added by DotNetKicks
7/30/2019 12:29:39 PM

2 Kicks, 217 Views

In the T-SQL language you can specify a positive integer constant in an ORDER BY clause as I've shown in the main image above. Please don't do this ! For those that haven't used this, the number refers to the position of the column in the SELECT list.