直接上代码
代码
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
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