Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    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?

    Thanks in advance.

  2. #2
    Join Date
    Dec 2002
    Posts
    3

    Sorry

    I am so sorry I did not notice I posted this in the wrong forum. I will repost in the correct forum :O

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •