sqlserver2000数据库中分页存储过程
摘要：
create procedure PageSql(@pageindex int,@pagecount int,@tablename varchar(30),@keyname varchar(30))asdeclare @count intdeclare @sqlstr varchar(1000)select @count=(@pageindex-1)*@pagecountset @sqlstr='select top '+cast(@pagecount as varchar)+' * from '+@tablename+' where '+@keyname+' not in (select t 阅读全文
posted @ 2011-01-19 17:00 神奇木马 阅读(384) 评论(0) 推荐(0) 编辑
