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 |
logisticblazer
Starting Member
4 Posts |
Posted - 2007-02-05 : 04:17:27
|
Im new to sql server 2000 can i change the order in the database is it possible. If anybody help me how to do it that would be a great help.Articles on various categories |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-05 : 04:25:54
|
What you want to change it to? what is the existing sort-order?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-05 : 04:34:13
|
I suspect you are after one of two things:Either you mean the collation (e.g. whether foreign accents are grouped with the letters they are associated with, or come separately in "alphabetical order")Or you mean that when you Query data you want to change the Order the data appears - in which case add an ORDER BY clause to the end of your SELECT statement [note that there is NO implied order of data in a Relational Database, and even if the data comes back in a suitable order today it may not tomorrow - unless you put ORDER BY on your SELECT queries]Kristen |
|
|
|
|
|