//根据审核状态自定义排序查询新闻表(按0,2,1的顺序排列)
select * from Article_News an ORDER BY charindex(','+CONVERT(varchar(10),an.N_isPublish)+',',',0,2,1,')
select * from 表名 ORDER BY charindex(','+CONVERT(varchar(10),列名)+',',',0,2,1,')
//根据审核状态自定义排序查询新闻表(按0,2,1的顺序排列)
select * from Article_News an ORDER BY charindex(','+CONVERT(varchar(10),an.N_isPublish)+',',',0,2,1,')
select * from 表名 ORDER BY charindex(','+CONVERT(varchar(10),列名)+',',',0,2,1,')