In the last episode (May 18), Stephen F. Johnston Jr. said:
> At 04:57 PM 5/18/99 -0500, you wrote:
> >PS: If I'm wrong, I'll send $10 US to the first person who convinces
> >me that SQL92 dictates order of insertion as a default ordering...
>
> SQL92 may even go so far as to explicitly say that the default order
> is however it comes out. :) However, an interesting note is that my
> msSQL server maintains insertion order quite well, but I would never
> rely on it.
Most databases I've seen maintain insertion order, but only until you
delete a record. Then the DB engine is free to insert the next record
into the unused space. This gets even more interesting when your
records are variable-length.
-Dan Nelson
dnelson@stripped
