给个例子:Create Proc sp_getRangeRecs (@strSQL nvarchar(4000),--待查询的SQL语句 @recStart int=1, --开始行 @recEnd int=999999) --结束行 As begin set nocount on declare @p1 int declare @recCount int set @recCount=@recEnd-@recStart+1 exec sp_cursorOpen @p1 output, @strSQL exec sp_cursorFetch @p1,16,@recStart ,@recCount exec sp_cursorClose @p1 end
(@strSQL nvarchar(4000),--待查询的SQL语句
@recStart int=1, --开始行
@recEnd int=999999) --结束行
As
begin
set nocount on
declare @p1 int
declare @recCount int
set @recCount=@recEnd-@recStart+1
exec sp_cursorOpen @p1 output, @strSQL
exec sp_cursorFetch @p1,16,@recStart ,@recCount
exec sp_cursorClose @p1
end