--按姓氏笔画排序
select * from student order by [name] collate chinese_prc_stroke_cs_as_ks_ws asc
--默认按姓氏拼音排序
select * from student order by [name] asc
--按姓氏拼音排序
select * from student order by [name] collate chinese_prc_cs_as asc
sql 按姓氏笔画（拼音）排序
原文：https://www.cnblogs.com/devgis/p/14181040.html
