[SQL] MSSQL 中文筆劃排序語法

#### 中文筆劃排序語法 (COLLATE Chinese_PRC_Stroke_ci_as) ####

SELECT * FROM [TableName]
ORDER BY [FieldName] COLLATE Chinese_PRC_Stroke_ci_as

#### 以注音符號排序語法 (COLLATE Chinese_Taiwan_bopomofo_CI_AS) ####

SELECT * FROM [TableName]
ORDER BY [FieldName] COLLATE Chinese_Taiwan_bopomofo_CI_AS

Reference: http://www.dotblogs.com.tw/topcat/archive/2008/09/18/5412.aspx