--按姓氏笔画排序

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