我现在有三个表xsact,tsact,tzaik
//===================
CREATE TRIGGER Op_SACT ON [dbo].[XSACT]
FOR INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted where akubu in ('K','J','T','L','I','Z')) --插入
begin
insert into tps_prices.dbo.tsact select PORDER,EDA,BUN,CODE,
BUMO,VENDOR,AKUBU,JITU,JITU0,APRICE,IDATE,FDATE,BUYER
from inserted;
end
if not exists (select 1 from inserted) --删除
begin
delete a from tps_prices.dbo.tsact a,deleted b
where a.porder=b.porder and a.eda=b.eda and a.bun=b.bun
endend//============上述代码可以完成向tsact中插入数据的操作=====CREATE TRIGGER Op_SecSACT ON [dbo].[TSACT]
FOR
INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted ) --插入
begin
update a
set a.price='0'
from tzaik a,inserted b
where a.code=b.code
end
end 可是这段代码为什么没改变,还请各位大侠帮忙!谢谢
//===================
CREATE TRIGGER Op_SACT ON [dbo].[XSACT]
FOR INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted where akubu in ('K','J','T','L','I','Z')) --插入
begin
insert into tps_prices.dbo.tsact select PORDER,EDA,BUN,CODE,
BUMO,VENDOR,AKUBU,JITU,JITU0,APRICE,IDATE,FDATE,BUYER
from inserted;
end
if not exists (select 1 from inserted) --删除
begin
delete a from tps_prices.dbo.tsact a,deleted b
where a.porder=b.porder and a.eda=b.eda and a.bun=b.bun
endend//============上述代码可以完成向tsact中插入数据的操作=====CREATE TRIGGER Op_SecSACT ON [dbo].[TSACT]
FOR
INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted ) --插入
begin
update a
set a.price='0'
from tzaik a,inserted b
where a.code=b.code
end
end 可是这段代码为什么没改变,还请各位大侠帮忙!谢谢
解决方案 »
- 用delphi访问IFRAME src指定的内网页里的内容,即子网页内容
- 报表问题,想把明细合并
- 我的Adoquery1连数据表,,问当我的数据表的任何数据改变会触发Adoquery1的什么事件?
- rmdir()的用法
- 菜鸟求助:这样的功能该怎么实现!
- 天,谁能救救我啊?——在线等待
- 计算个人所得税算法
- delphi7调用com遇到的奇怪问题,急!!!
- 经常需要传输 1M..20M 不定的文件包,用什么传?HTTP可以不?现在小WEB svr 很多的...
- 为何无法调用DLL文件?
- 我对Explorer ,hook了TextOut()、ExtTextOut()函数
- 请教一下:按钮带下拉,大家怎么实现的?
CREATE TRIGGER Op_SecSACT ON [dbo].[TSACT]
FOR
INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted )
begin
update tzaik
set price='0'
from tzaik a,inserted b
where a.code=b.code
end
end
請檢查下你的判斷條件,如果不是刪除操作才執行???
顺便说一句,xsact是一个库,tsact,tzaik又是另外一个库(tps_prices)
我现在有三个表xsact,tsact,tzaik
//===================
CREATE TRIGGER Op_SACT ON [dbo].[XSACT]
after INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted where akubu in ('K','J','T','L','I','Z')) --插入
begin
insert into tps_prices.dbo.tsact select PORDER,EDA,BUN,CODE,
BUMO,VENDOR,AKUBU,JITU,JITU0,APRICE,IDATE,FDATE,BUYER
from inserted;
end
if not exists (select 1 from inserted) --删除
begin
delete a from tps_prices.dbo.tsact a,deleted b
where a.porder=b.porder and a.eda=b.eda and a.bun=b.bun
endend//============上述代码可以完成向tsact中插入数据的操作=====CREATE TRIGGER Op_SecSACT ON [dbo].[TSACT]
after
INSERT, UPDATE, DELETE
AS
begin
if not exists (select 1 from deleted ) --插入
begin
update a
set a.price='0'
from tzaik a,inserted b
where a.code=b.code
end