按姓氏笔画排序
Select * From TableName Order By Name Collate Chinese_PRC_Stroke_CI_AS
按姓氏拼音排序
SELECT * FROM TableName ORDER BY [name] COLLATE Chinese_PRC_CS_AS_KS_WS
按姓氏笔画排序
Select * From TableName Order By Name Collate Chinese_PRC_Stroke_CI_AS
按姓氏拼音排序
SELECT * FROM TableName ORDER BY [name] COLLATE Chinese_PRC_CS_AS_KS_WS