sp_cursoropen

[caoyang0299]

declare @p1 int
set @p1=180157019
declare @p3 int
set @p3=16
declare @p4 int
set @p4=1
declare @p5 int
set @p5=1
exec sp_cursoropen @p1 output,N'SELECT "T0"."FID" "ID", "T0"."FNAME_L2" "NAME", "T0"."FNAME_L1" "NAME_L1", "T0"."FNAME_L2" "NAME_L2", "T0"."FNAME_L3" "NAME_L3", "T0"."FISDEFAULT" "ISDEFAULT", "T0"."FTYPE" "TYPE", "T0"."FCONFIG" "CONFIG", "T0"."FOWNERID" "T1.ID", "T0"."FUIVIEWID" "T2.ID", "T2"."FUIPK" "T2.UIPK" FROM "T_BD_DYNAMICLISTSETTING" "t0" LEFT OUTER JOIN "S_BS_UIVIEW" "t2" ON "T0"."FUIVIEWID" = "T2"."FID" WHERE (("T0"."FUIVIEWID" = @P0 AND "T0"."FISDEFAULT" = @P1 ) AND (("T0"."FTYPE" = @P2 AND "T0"."FSTATE" = @P3 ) OR ("T0"."FOWNERID" = @P4 AND "T0"."FCATEGORY" = @P5 ))) ORDER BY "TYPE" DESC, "T0"."FCREATETIME" ASC',@p3 output,@p4 output,@p5 output,N'@P0 nvarchar(4000),@P1 int,@P2 int,@P3 int,@P4 nvarchar(4000),@P5 nvarchar(4000)',N'dFpqbVDpTV+b5z8t3wlhzRRypnI=',1,1,1,N'dz/XcmdlTQmUnhSqKHTctxO33n8=',N'kwQBy5kxTOexeFHnY8sWCP/N8rE='
select @p1, @p3, @p4, @p5

exec sp_cursorfetch 180157019,2,1,100

后台跟踪到的一段代码，exec sp_cursoropen是生成游标吧，exec sp_cursorfetch 是读取游标
exec sp_cursorfetch 180157019,2,1,100
sp_cursorfetch 180157019这是怎么个意思，谢谢！

[卖水果的net]

好早之前的一个贴子了，你参考 一下。 http://bbs.csdn.net/topics/390583938

[中国风]

SQL2005之后的版本参照
http://bbs.csdn.net/topics/391978221

这是SQL2000之前的版本用的方法：

贴个中文MSDN联机
sp_cursorfetch
https://msdn.microsoft.com/zh-cn/library/ff848736

[中国风]

游标存储过程
https://msdn.microsoft.com/zh-cn/library/ms187801

[中国风]

上面改为直接贴MSDN中文有语法说明连接，不明时再问