SQL Sort Order?

Results 1 to 3 of 3

Thread: SQL Sort Order?

  1. #1
    Join Date
    Dec 1969

    Default SQL Sort Order?

    I was just in a meeting and someone told me that in order to move my application to production they need to know my SORT ORDER on my SQL server, when I questioned them further they said it was in the settings of the actually server, they said I can find out what the sort order is by typing a simple query into the analyzer, any suggestions as to how I can do this?<BR><BR>Johnny

  2. #2
    . Guest

    Default RE: SQL Sort Order?

    swallow your pride and ask the guy who yuo were talking to EXACTLY what he meant - even to show you haw to do it.

  3. #3
    Join Date
    Dec 1969

    Default RE: SQL Sort Order?

    In query anazlyser type "sp_helpsort" this is a stored procedure in SQL Server that will tell you about the server&#039;s sort order and collation. These were settings that were set when the Server was loaded. You will need access to the SQL Server tools to access the query analyzer.<BR><BR>HTH,<BR>Justin

Posting Permissions

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