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 |
|
codrgiii
Starting Member
29 Posts |
 Posted - 2011-06-12 : 13:14:08
|
| When i open a table in sql 2005, my columns are not organised and when i open the table i would like to see them ordered by date. I have a column named Date, which is smalldatetime, how would i organise the rows there by date in ascending order so when i open the table they are organised? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-12 : 13:40:23
|
| Use the query editor and write a select statement with an ORDER BY clause, instead of just opening the table with the GUI.SELECT top 100 * FROM yourTable ORDER BY [date] ASC; |
 |
|
|
codrgiii
Starting Member
29 Posts |
Posted - 2011-06-13 : 10:17:11
|
| So it's not possible in sql to do what i asked? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-13 : 10:21:05
|
| Um, yes it is, did you read russel's reply? |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-06-13 : 10:22:26
|
Of course it's possible in SQL... but you are specifically asking if it can be done in an app (probably SSMS - SQL Server Management Studio) and not SQL.quote:
Originally posted by codrgiii
So it's not possible in sql to do what i asked?
Corey I Has Returned!! |
|
|
|
|
|
|
organise a table?