Sql Server2005学习笔记（存储过程：分页小程序）

分页小程序的存储过程

--创建临时表create table #tem2(num int identity(1,1),id int,)--创建存储过程if exists(select name from sys.all_objects where name = 'pagingProd' and type = 'P')drop procedure pagingProdgocreate procedure pagingProd@start int,--分页开始位置@end int,--分页结束位置@table varchar(20)--表名asbeginexec('insert into #tem2 select id from '+@table)exec('select * from #tem2 t,'+@table+' pwhere t.id = p.id and t.num between '+@start+' and '+@end)end--执行存储过程execute pagingProd 11,15,'product'