Create&nbs
p;PRocedure sp_pageQuery
@
SQLstr nv
Archar(4000),
@page_index int,
@page_size int ,
@rec_count int out --
as
set nocount on
declare @cursor_id int
declare @
rowcount int
exec sp_cursoro
PEn @cursor_id output,@sqlstr,@scrollopt=1,@ccopt=1,@rowcount=@rowcount output
set @rec_count=@rowcount
set @page_index=(@page_index-1)*@page_size+1
IF @rec_count>0
BE
gin exec sp_cursorfetch @cursor_id,16,@page_index,@page_size
END
ELSE
BEGIN
Select '
test'='null' Where 1=2
END
exec sp_cursorclose @cursor_id
set nocount off
GO