Tip: Using ORDER BY in a View or Derived Table


T-SQL syntax doesn't support an ORDER BY clause in a view or a derived table unless you also include the TOP keyword as part of the SELECT statement. SQL Server 2000's error message hints at this fact by suggesting that the TOP keyword will help, as the example in Figure A shows. But you can circumvent this restriction by including a TOP 100 PERCENT clause, as the example in Listing A shows.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.