摘要:
我经常犯的错误。如:写一个分页存储过程if exsits (select * from sysobjects where name='proce')dorp procedure procegocreate procedure proce@pagezise int,@pageno intasselect * from (select row_number() over (order by t1) as rowid) as mm where rowid between (@pageno-1)*@pagesize and @pageno*@pagesizego--执行存储过程(该分页 阅读全文