CREATE Proc SP_SynchronizeDLFXSFInfo @PARA1 VARCHAR(200),@PARA2 VARCHAR(200),@PARA3 VARCHAR(200),@PARA4 VARCHAR(200),@PARA5 VARCHAR(1)
WITH ENCRYPTION
AS
SET XACT_ABORT on
BEGIN TRAN EXEC ('UPDATE DLYH SET JSRQ='''+@PARA2+''',YS=(DLYH.YS-HAA.C) FROM
(select yhh as A,SUM(hjdf) AS C from
openquery(ora,''select * from ' +@PARA1+ ' .view_dlfx'')
where fxrq >='''+@PARA2+''' and fxrq <=dateadd(day,1, '''+@PARA3+''' ) and ( JH ='+@PARA4+') group by yhh ) HAA,DLYH WHERE
DLYH.YHH=HAA.A')IF @@error <> 0
BEGIN
ROLLBACK TRANSACTION
END
ELSE
COMMIT TRANSACTIONgo
WITH ENCRYPTION
AS
SET XACT_ABORT on
BEGIN TRAN EXEC ('UPDATE DLYH SET JSRQ='''+@PARA2+''',YS=(DLYH.YS-HAA.C) FROM
(select yhh as A,SUM(hjdf) AS C from
openquery(ora,''select * from ' +@PARA1+ ' .view_dlfx'')
where fxrq >='''+@PARA2+''' and fxrq <=dateadd(day,1, '''+@PARA3+''' ) and ( JH ='+@PARA4+') group by yhh ) HAA,DLYH WHERE
DLYH.YHH=HAA.A')IF @@error <> 0
BEGIN
ROLLBACK TRANSACTION
END
ELSE
COMMIT TRANSACTIONgo
解决方案 »
- sql 执行计划成本
- 将一个数据类型为nvarchar的字段的值分别赋值给一个数据类型为nchar的字段和一个数据类型为ntext字段
- 求助:向各位大哥请教一个 output 参数的问题,谢谢!
- SOS, Help !!! 通讯模块无效,驱动程序安装不正确
- win7中AdoConnection断开后连接字符串里面就找不到password了
- 分解字符串并插入语句 -- 哪位高手来帮帮忙
- set noexec on 属性设置
- 关于sysobjects中的name字段的访问的问题。在线等!!!!
- 请教各位大侠,如何得到字段的默认值
- 我想记录用户操作数据库的日志怎么办?
- 大力又要麻烦你了!我是beyondyw在来帮你加分
- 为何dbgrid的竖滚动条下拉不是按照一条记录一条记录往下走呀
WITH ENCRYPTION
AS
set XACT_ABORT on
SET ANSI_NULL_DFLT_ON on
SET ANSI_WARNINGS on EXEC ('UPDATE DLYH SET JSRQ='''+@PARA2+''',YS=(DLYH.YS-HAA.C) FROM
(select yhh as A,SUM(hjdf) AS C from
openquery(ora,''select * from ' +@PARA1+ ' .view_dlfx'')
where fxrq >='''+@PARA2+''' and fxrq <=dateadd(day,1, '''+@PARA3+''' ) and ( JH ='+@PARA4+') group by yhh ) HAA,DLYH WHERE
DLYH.YHH=HAA.A')
go
WITH ENCRYPTION
AS
exec('
set XACT_ABORT on
SET ANSI_NULL_DFLT_ON on
SET ANSI_WARNINGS on select * into #临时表 from openquery(ora,''select * from ' +@PARA1+ ' .view_dlfx'') tem
where fxrq >='''+@PARA2+''' and fxrq <=dateadd(day,1, '''+@PARA3+''' ) and ( JH ='+@PARA4+') group by yhh )update DLYH set JSRQ='''+@PARA2+''',YS=(DLYH.YS-HAA.C) from #临时表 HAA where DLYH.YHH=HAA.A')go
?????