"Orchid XP v8" <voi### [at] devnull> wrote in message 
news:48caab2e$1@news.povray.org...
> Gail wrote:
>>
>> "Invisible" <voi### [at] devnull> wrote in message 
>> news:48ca7536$1@news.povray.org...
>>>
>>> I guess it depends what you're trying to do. SQL certainly has a few 
>>> known flaws (default column orderings, anyone?), but in general it makes 
>>> it quite simple and easy to do most things.
>>
>> What column orderings?
>
> Apparently some people consider it a bug that you can write queries that 
> depend on the order in which columns are returned (rather than by explicit 
> column names). Since relations are supposed to be sets, that shouldn't be 
> the case.

Some people consider it a bug that the order of rows is undefined without an 
order by statement.
Fortunatly for my sanity (and that of a few other people) in T-SQL columns 
are always returned in the same order if SELECT * is specified. It's the 
order of the column in the system tables.

Post a reply to this message