sql 存储过程分页 CREATE PROC myx_prPageRecordset@queryStr nvarchar(1000), @keyField nvarchar (200), @pageSize int, @pageNumber int ASBEGINDECLARE @sqlText AS nvarchar(4000)DECLARE @sqlTable AS nvarchar(4000)SET @sqlTable = 'SELECT TOP ' + CAST((@pageNumber + 1) * @pageSize AS varchar(30)) + ' ' + @queryStrSET @sqlText ='SELECT TOP ' + CAST(@pageSize AS varchar(30)) + ' * ' + 'FROM (' + @sqlTable + ') AS tableA ' +'WHERE ' + @keyField + ' NOT IN(SELECT TOP ' +CAST(@pageNumber * @pageSize AS varchar(30)) + ' ' + @keyField + ' FROM (' + ...
查看详细内容 >>