Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What Is @@DEF_SORTORDER_ID Used For?

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)?

like image 834
Question3CPO Avatar asked Aug 06 '13 15:08

Question3CPO


1 Answers

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...

like image 156
Remus Rusanu Avatar answered Nov 05 '22 21:11

Remus Rusanu