fn_helpcollations (Transact-SQL)

語法

fn_helpcollations ()

傳回的資料表

fn_helpcollations 傳回下列資訊。

範例

下列範例會傳回開頭是 L 字母，而且是二進位排序定序的所有定序名稱。

USE AdventureWorks2008R2;
SELECT Name, Description FROM fn_helpcollations()
WHERE Name like 'L%' AND Description LIKE '% binary sort';

以下為結果集：

Name Description

------------------- ------------------------------------

Lao_100_BIN Lao-100, binary sort

Latin1_General_BIN Latin1-General, binary sort

Latin1_General_100_BIN Latin1-General-100, binary sort

Latvian_BIN Latvian, binary sort

Latvian_100_BIN Latvian-100, binary sort

Lithuanian_BIN Lithuanian, binary sort

Lithuanian_100_BIN Lithuanian-100, binary sort

(7 個資料列受到影響)

請參閱

參考