select top 10 *,publishtime from works order by convert(varchar(10),publishtime,120) desc,convert(varchar(8),publishtime,108) asc
楼上的那个top 10 ,表里面的数据是一直增加的不同用哦。。
OK,谢谢了,加上楼上两位的答案,自己加工下就可以用了 exec (' select top '+ @pagercount + ' *,publishtime from works order by convert(varchar(10),publishtime,120) desc,convert(varchar(8),publishtime,108) asc ')
exec (' select top '+ @pagercount + ' *,publishtime from works order by convert(varchar(10),publishtime,120) desc,convert(varchar(8),publishtime,108) asc ')