MSSQL 按照字段中文比划排序

直接上代码

insert #t select 1,'三'
union all select 2,'乙'
union all select 3,'二'
union all select 4,'一'
union all select 5,'十'
select * from #t order by name collate chinese_prc_stroke_cs_as_ks_ws  
drop table #t