Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Re: Re: Database Record Order

by mpeppler (Vicar)
on Dec 31, 2003 at 22:19 UTC ( #318029=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Database Record Order
in thread Database Record Order

If this is an MS-SQL server then the "default" order is likely to be the order of the clustered index. However, relying on that ordering when using an RDBMS is unwise, as it could change at any time, or be different if you move your script from one type of database server to another, or if other DDL changes (such as different indexes, different locking methods, etc) are applied.

In short - never rely on the order of data in a SELECT without an ORDER BY clause.

Michael

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://318029]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (1)
As of 2023-01-28 20:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?