随笔分类 - 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 ...
阅读全文
浙公网安备 33010602011771号