日期:2014-05-17 浏览次数:20801 次
with tb(a) as(
select '13-1' union all
select '13-12' union all
select '13-130' union all
select '14-18' union all
select '14-22' union all
select '14-100'
)
select * from tb
order by convert(int,left(a,charindex('-',a)-1)),
convert(int,right(a,len(a)-charindex('-',a)))