title: Why use Select Top 100 Percent?
body: <p>I understand that prior to <em>SQL Server 2005</em>, you could "trick" SQL Server to allow use of an order by in a view definition, by also include <code>TOP 100 PERCENT</code> in the <em>SELECT</em> clause. But I have seen other code which I have inherited which uses <code>SELECT TOP 100 PERCENT</code> ... within dynamic SQL statements (used in <em>ADO</em> in  <em>ASP.NET</em> apps, etc). Is there any reason for this? Isn't the result the same as <strong>not</strong> including the <code>TOP 100 PERCENT</code>?</p>