All geek questions in one place

What is @@ DEF_SORTORDER_ID used for?

I looked at the Microsoft SQL Server site , Googled this one and even checked the Stack Overflow for an answer (note the last two, it will change within a day or so), and yet I can not find anything for the below SELECT query:

 SELECT @@DEF_SORTORDER_ID

What / how is it used in SQL Server (2008R2, it is also available in 2012 and 2005)?

+6
source share
1 answer

To get the SQL sort order identifier, use SERVERPROPERTY('SqlSortOrder') . The list of sort orders for ancient SQL 7.0 products is still available in places such as here . Currently, although everyone calls it 'server mapping .

Saying, I've never seen @@DEF_SORTORDER_ID , and I don't know what it is ...

+3
source

Source: https://habr.com/ru/post/951144/

More articles:


All Articles