sql server 利用首字母拼音排序和笔画排序的语句

 

--按笔画排序

select * 
from Student
order by Sname COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS

 

--按字母拼音排序

select * 
from Student 

order by Sname COLLATE Chinese_PRC_CS_AS_KS_WS