如何找出SQL 2000/2005中可用的排序规则

SELECT *
FROM sys.collations
WHERE locale = USER_DEFAULT_LOCALE;

SELECT collation_name
FROM (
    SELECT collation_name FROM sys.collations WHERE locale = USER_DEFAULT_LOCALE
    UNION ALL
    SELECT collation_name FROM sys.collations
    WHERE locale = USER_LOCALE
    UNION ALL
    SELECT collation_name FROM sys.collations
    WHERE is_user_defined = 1
) AS collations
ORDER BY collation_name ASC;