Hello.
Is it possible to change the underlying order of a table with DESC ?
I run a game server where items are offered for sale.
Users call up lists of items which need to be displayed as most recent at the top.
Having learnt that I can add ORDER BY FLD_SELLDATE DESC to the list calling stored procedures, I can correct the bug and display items in the correct order.
However, there is one list option that has no associated stored procedure and that's the full item list so I can't sort this with DESC, hence my question.
If it is possible to change the whole table, would this negate the changes made to the stored procedures ?
Thanks
PS
I'm using MS SQL Server Management Studio 2012