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

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

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

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

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

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