CREATE trigger make_tag on finanle_oderbuy
for insert,update
as
begin
insert into finanle_oderbuy (tag) select '0'
where (select requirement from inserted) in (select finanle_budget.requirement from finanle_budget)
end
begin
if exists (select requirement from youtable where 条件)
insert into finanle_oderbuy (tag) select '1'
else
insert into finanle_oderbuy (tag) select '0'
end
go
for insert,update
as
begin
insert into finanle_oderbuy (tag) select '0'
where (select requirement from inserted) in (select finanle_budget.requirement from finanle_budget)
end
begin
if exists (select requirement from youtable where 条件)
insert into finanle_oderbuy (tag) select '1'
else
insert into finanle_oderbuy (tag) select '0'
end
go
----------
CREATE trigger make_tag on finanle_oderbuy
for insert,update
as
if exists (select requirement from youtable where 条件)
insert into finanle_oderbuy (tag) select '1'
else
insert into finanle_oderbuy (tag) select '0'
go
for insert,update
asdeclare @tag char(1)IF (select requirement from inserted) in (select finanle_budget.requirement from finanle_budget)
SET @tag = '0'
ELSE
SET @tag = '1'
UPDATE finanle_oderbuy SET tag = @taggo
CREATE trigger make_tag on finanle_oderbuy
for insert,update
asdeclare @tag char(1)IF (select requirement from inserted) in (select finanle_budget.requirement from finanle_budget)
SET @tag = '0'
ELSE
SET @tag = '1'
UPDATE finanle_oderbuy SET tag = @tag WHERE requirement = (select requirement from inserted)go