幻灯片背景图片大全,俞夏被谁带走,免费算命网
create procedure sp_pagequery
@sqlstr nvarchar(4000),
@page_index int,
@page_size int ,
@rec_count int out --
as
set nocount on
declare @cursor_id int
declare @rowcount int
exec sp_cursoropen @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
begin
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
在要用的时候在那个存储过程里调用
create procedure [dev].[p_mobile_comment_page]
@course_ware_id int,
@reccountperpage int=1,
@pageindex int =1,
@recordcount int=0 out
as
declare @sql nvarchar(4000)
set @sql="
select seg_id,course_ware_id,subject,cust_name,content,create_date
from t_courseware_comment
where course_ware_id="+cast(@course_ware_id as varchar(10))+"
order by seg_id"
exec sp_pagequery @sql,@pageindex,@reccountperpage,@recordcount out
go
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!!
点击进行留言回复
相关文章:
-
-
详解SQL游标的用法
类型: 1.普通游标 只有next操作 2.滚动游标 有多种操作1.普通游标declare @username varchar(20),@userid varc...
[阅读全文]
-
-
-
-
-
-
-
-
-
网友评论