随笔分类 -  SQL问题

SQL分页存储过程中排序问题
摘要:create procedure procPage @startIndex int,@endIndex int,@sort varchar(50)='asc'aswith pageTamp as(select row_number() over(order by id @sort) as row,* from dbo.WZ_YouQing)select * from pagetamp where ... 阅读全文
posted @ 2009-10-08 17:15 黛玉 阅读(204) 评论(0) 推荐(0)