sql 按姓氏笔画（拼音）排序

 

--按姓氏笔画排序
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