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%

Views

Daily Counts

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

Views

License

Comments and Discussions