存储过程_分页存储过程

--创建分页存储过程

USE stusGOIF EXISTS(SELECT * FROM sysobjects WHERE name='up_stufy')DROP PROC up_stufyGOCREATE PROC up_stufy@page INT,@count INT,@table NVARCHAR(10),@str NVARCHAR(800) outputASSET @str='SELECT TOP ' +CONVERT(VARCHAR(10),(@count))+' * FROM '+@table+' where id not in'+' (select top '+CONVERT(VARCHAR(10),((@page-1)*@count))+' id from '+@table+')'go

--调用分页存储过程

DECLARE @str NVARCHAR(800)EXEC up_stufy 2,3,'stu',@str OUTPUTEXEC sp_executesql @str

是不是很简单？学习就是需要多想多敲你才会有所收获！