create trigger tr_test on ManTable for update as if update(ZT) and update ModifyTable set Num = b.Num from inserted a,Detail b where ModifyTable.id=ModifyID and ZT=Complete
create trigger tr_test on ManTable for update as if update(ZT) update ModifyTable set Num = b.Num from inserted a,Detail b where ModifyTable.id=ModifyID and ZT=Complete and -- inserted (ManTable)与Detail的关系
create trigger tr_test on ManTable for update as if update(ZT) and update ModifyTable set Num = b.Num from inserted a,Detail b where ModifyTable.id=ModifyID and ZT=Complete
再擴展一點:細表中還有一字段 ordNum(int型初始值為0) 現將 該字段的值 修必為在原來基礎上 + Num
create trigger tr_test on ManTable for update as declare @ZT char(20) select @ZT=ZT from inserted if update(ZT) and rtrim(ltrim(@ZT))='Complete' begin update ModifyTable set Num = b.Num from ModifyTable a ,Detail b where a.id=b.ModifyID end go 没有调试。 循环在数据库中会处理。
create trigger tr_test on ManTable for update as declare @ZT char(20) select @ZT=ZT from inserted if update(ZT) and rtrim(ltrim(@ZT))='Complete' begin update ModifyTable set Num = b.Num from ModifyTable a ,Detail b where a.id=b.ModifyID update Detail set OrdNum=OrdNum+Num
end go
create trigger tr_test on ManTable for update as if update(ZT) update ModifyTable set Num =NUM+ b.Num from inserted a,Detail b where ModifyTable.id=ModifyID and ZT=Complete and -- inserted (ManTable)与Detail的关系
inserted 代表什? 是不是 我這里的 主表要是我用再在一個表中新加一條記錄,而記錄的值 為 一些關其他聯表中的值 如 在表 C 中 新加一條: insert into c(庫位,庫房) values(MainTabel.庫位,CK.庫房 where MainTabel.庫位=CK.庫位)這怎寫
for update
as
if update(ZT) update ModifyTable set Num = b.Num
from inserted a,Detail b
where ModifyTable.id=ModifyID and ZT=Complete
and
-- inserted (ManTable)与Detail的关系
for update
as
if update(ZT) and
update ModifyTable set Num = b.Num
from inserted a,Detail b
where ModifyTable.id=ModifyID and ZT=Complete
現將 該字段的值 修必為在原來基礎上 + Num
for update
as
declare @ZT char(20)
select @ZT=ZT from inserted
if update(ZT) and rtrim(ltrim(@ZT))='Complete'
begin
update ModifyTable set Num = b.Num
from ModifyTable a ,Detail b
where a.id=b.ModifyID
end
go
没有调试。
循环在数据库中会处理。
for update
as
declare @ZT char(20)
select @ZT=ZT from inserted
if update(ZT) and rtrim(ltrim(@ZT))='Complete'
begin
update ModifyTable set Num = b.Num
from ModifyTable a ,Detail b
where a.id=b.ModifyID
update Detail set OrdNum=OrdNum+Num
end
go
for update
as
if update(ZT)
update ModifyTable set Num =NUM+ b.Num
from inserted a,Detail b
where ModifyTable.id=ModifyID and ZT=Complete
and
-- inserted (ManTable)与Detail的关系
是不是 我這里的 主表要是我用再在一個表中新加一條記錄,而記錄的值 為 一些關其他聯表中的值
如
在表 C 中 新加一條:
insert into c(庫位,庫房)
values(MainTabel.庫位,CK.庫房 where MainTabel.庫位=CK.庫位)這怎寫
細表 有一字段為 mainIDTO:
caiyunxia(monkey)那樣是不是將所有的 明細的 ordNum 都 加上 Num 了?這樣吧有誰能和我用MSN嗎
[email protected]