Re: SQL 2000, SP3a "TOP 100%"

> you need TOP 100% for a view
>
> you can't use an order by in a view without a top 100%

You don't need TOP 100% for views and you shouldn't use ORDER BY in views
either. Views are supposed to be unordered and with good reason. Queries
against the view may well perform better without an ORDER BY clause in the
view definition. The best place to use ORDER BY is when you query the view.

--
David Portas
SQL Server MVP
--


.

Relevant Pages

  • Re: Query question?
    ... Better specs would help us with future questions. ... David Portas ... SQL Server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver)
  • Re: Price of SQL Server
    ... Workgroup Edition ... David Portas ... SQL Server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Re: datafile and log file on cluster
    ... files on separate physical disks. ... David Portas ... SQL Server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Re: Whats wrong ?
    ... Your query is syntactically valid so the problem is in your ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: How to connect to a dedicated m/c
    ... Windows 2003. ... David Portas ... SQL Server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver.connect)
Loading