|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 06/06/2012 : 06:09:16
|
Unpredictable. Depends on how the query is executed and the storage chain. The order can change at any time.
In general if an index is used the rows will be returned in order of that index but parallelism and joins can affect that.
Same as if you don't have an order by clause.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
Edited by - nigelrivett on 06/06/2012 06:09:46 |
 |
|
Default order if order by values are all equal
