Unanswered: Two Questions about SQL Server vs Access
I've just converted my site over from Access to SQL Server (only on my computer, I haven't uploaded it to my site). Anyway, I have a few questions about running SQL Commands on an SQL Server.
1) I used to be able to run this portion of an SQL Statement ..."ORDER BY [Networth] DESC, [TotalLand] DESC, [Country Name]", however it seems SQL Server cannot order by a text field... how do I fix this?
2) I used to have an Autonumber field in Access. The Upsizing wizard correctly converted it to a int field with increment. However, sometimes I want to delete all the records and start the incrementing over. I used to copy and paste a "Structure Only" version of the table in Access to fix this, but how do I do it with an SQL Database?