Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imrul
Starting Member
36 Posts |
 Posted - 2010-04-08 : 05:46:38
|
| I am using SQL 2008. I have a table named Stting with a primary key LoadId (Varchar(20)).When I use query "Select * From Stting" data are not retriving in soreted order based on primary key.But in SQL 2000 I get the data in sorted. Due to a project constrained I cannot use order by clause. Can any one help?LoadID ---------- 1002311001 1002293001 1002299001 1002319001 1002304001 1002287001 1002256001 1002318001 1002315001 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-08 : 05:52:51
|
Without using ORDER BY there is NEVER a reliable order.Hence the project constrained isn't very useful if you need your result set in a wanted order.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-04-08 : 06:10:55
|
| There is a behavior change in SQL Server 2008 compared to 2000. So whatever works by default in 2000, may not work in 2008MadhivananFailing to plan is Planning to fail |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-08 : 07:25:44
|
quote:
Originally posted by imrul]Due to a project constrained I cannot use order by clause. Can any one help?
I'm interested in this bit. What sort of project constraint would prevent you from using an ORDER BY?There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
|
|
|
Default order in select query.