Posted by Tony Rogerson on 01/30/06 12:16

Hi Doug,

Once you use ORDER BY the query results fail to be a set and instead are
linear data which then makes columns fields of data and rows records of
data!

Tony.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Doug" <drmiller100@hotmail.com> wrote in message
news:1138583869.933814.248480@g43g2000cwa.googlegroups.com...
> >Someone was asleep in their RDBMS class! What is the most basic
> property of a Table? It has no ordering by definition. To get an
> ordering, you have to have a cursor.
>
> Ummm, sort of. A table in and of itself does not have an order.
> However, you can definately get the data contained within that table
> returned to you in pretty much order you want.
>

• Next in forum: Re: How to find first not null value in column
• Prev in forum: Re: ORDER BY in VIEW not working
• Thread view: Re: ORDER BY in VIEW not working

[Reply to this message]