SQL Select Top 100 % forgets Order By Clause

Daniel Ch. Bloch (MCSD, MCAD, MCTS)

Rate me:

3.00/5 (7 votes)

19 Mar 2008CPOL1 min read

29.5K

SQL 2005+ changes behaviour of order by in relation to Select top 100%

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Daniel Ch. Bloch (MCSD, MCAD, MCTS)

Software Developer (Senior) http://www.btv-data.ch

Switzerland

On software development since 1992, going through the different steps from mainframe computing with VMS/Vax over VB4-6, Access and SQL server, Cold Fusions and ASP programming to my currently status as Chief Solution Developer for Smartclient and Client/Server development with vb.net and SQL Server. MCSD and some other stuff.

SQL Select Top 100 % forgets Order By Clause

Alternatives

License

Comments and Discussions