单独的:在-上面 包含的却相反 这是什么原因?
create table #aaa(a nvarchar(50))
insert into #aaa(a) values('5555')
insert into #aaa(a) values('77')
insert into #aaa(a) values('8')
insert into #aaa(a) values(':')
insert into #aaa(a) values('-')
insert into #aaa(a) values('856:33')
insert into #aaa(a) values('856-33')
insert into #aaa(a) values(':33')
insert into #aaa(a) values('-33')
select * from #aaa order by a desc
drop table #aaa
------解决方案--------------------
排序取决于列的排序规则。排序规则是 ?
参考 http://technet.microsoft.com/zh-cn/library/ms190920(v=sql.105).aspx