--(1)借用字符串进行无规律排序 create table #DepartMent ( Depart varchar(10) ) insert into #DepartMent select '组长' union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' declare @sql varchar(100) set @sql=N'总经理,副总经理,主管,组长,助理,员工' select * from #DepartMent order by charindex(N','+Depart+N',',N','+@sql+N',')