摘要: 我经常犯的错误。如:写一个分页存储过程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--执行存储过程(该分页 阅读全文
posted @ 2012-11-07 11:31 小凤梨子 阅读(791) 评论(1) 推荐(0) 编辑