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