fn_helpcollations (Transact-SQL)
SQL Server 2005
傳回 Microsoft SQL Server 2005 所支援之所有定序的清單。
下列範例會傳回開頭是 L 字母，而且是二進位排序定序的所有定序名稱。
USE AdventureWorks; SELECT Name, Description FROM fn_helpcollations() WHERE name like 'L%' AND description LIKE '% binary sort';
以下為結果集：
Name Description ------------------- ------------------------------------ Latin1_General_BIN Latin1-General, binary sort Latvian_BIN Latvian, binary sort Lithuanian_BIN Lithuanian, binary sort Lithuanian_Classic_BIN Lithuanian-Classic, binary sort (4 row(s) affected)
社群新增項目
新增
顯示:
