I've looked through Microsoft's SQL Server site, Googled this, and even checked Stack Overflow for an answer (note on the last two, this will change within a day or so), and yet I'm not finding anything for the below SELECT
query:
SELECT @@DEF_SORTORDER_ID
What/how is this used in SQL Server (2008R2; it also appears to be available in 2012 and 2005)?
To get the SQL sort order ID, use SERVERPROPERTY('SqlSortOrder')
. The list of sort orders for ancient SQL 7.0 products is still available in places like here. Nowadays though everybody calls it 'the server collation'.
That being said, I never seen @@DEF_SORTORDER_ID
before and I don't know what it is...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With