1 --创建分页存储过程
2 USE stus
3 GO
4 IF EXISTS(SELECT * FROM sysobjects WHERE name='up_stufy')
5 DROP PROC up_stufy
6 GO
7 CREATE PROC up_stufy
8 @page INT,
9 @count INT,
10 @table NVARCHAR(10),
11 @str NVARCHAR(800) output
12 AS
13
14 SET @str='SELECT TOP ' +CONVERT(VARCHAR(10),(@count))+' * FROM '+@table+' where id not in'+
15 ' (select top '+CONVERT(VARCHAR(10),((@page-1)*@count))+' id from '+@table+')'
16 go
17 --调用分页存储过程
18 DECLARE @str NVARCHAR(800)
19 EXEC up_stufy 2,3,'stu',@str OUTPUT
20 EXEC sp_executesql @str
21
22 是不是很简单？学习就是需要多想多敲你才会有所收获！
