22,210
社区成员
发帖
与我相关
我的任务
分享
declare @P1 int
set @P1=180150000
declare @P2 int
set @P2=1
declare @P3 int
set @P3=1
declare @P4 int
set @P4=4
exec sp_cursoropen @P1 output, N' select a.jhxh,a.fbrq,a.jhmc,a.jhms,a.jhlb,a.wcbz,zzrq,a.sjwcrq,a.jhlj,wcsqr,b.ygxm,a.IP,a.IP2,a.DABH,a.KHBH,a.quick,a.Location,c.hostlocation from HXX_NEW a left join RS_YGB b on a.jhfbr=b.ygbh left join oa_gdzc_cp_new c on a.DABH=c.bh where a.Location=2 and a.wcbz<=2 order by a.wcbz asc,a.quick desc,a.jhxh desc', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
select a.jhxh,a.fbrq,a.jhmc,a.jhms,a.jhlb,a.wcbz,zzrq,a.sjwcrq,a.jhlj,wcsqr,b.ygxm,a.IP,a.IP2,a.DABH,a.KHBH,a.quick,a.Location,c.hostlocation from HXX_NEW a left join RS_YGB b on a.jhfbr=b.ygbh left join oa_gdzc_cp_new c on a.DABH=c.bh where a.Location=2 and a.wcbz<=2 order by a.wcbz asc,a.quick desc,a.jhxh desc
..set @P4=4exec sp_cursoropen
呢?