create trigger tr_YK_NewRequirement_Sub ON YK_NewRequirement_Sub after update,insert as if ((select StartDate from deleted)<>(select StartDate from inserted)) and exists(select * from inserted where Stage='客户验证') begin insert into YK_NewRequirement(FirstSubmittedDate) select StartDate from inserted end
use xuanya if object_id('shu','tr') is not null drop trigger shu go create trigger shu on YK_NewRequirement_Sub after insert,update as begin if(YK_NewRequirement_Sub.StartDate=inserted.StartDate) and(YK_NewRequirement_Sub.Stage='客户验证') begin insert into YK_NewRequirement(FirstSubmittedDate) select StartDate from inserted end end
create trigger tr_YK_NewRequirement_Sub
ON YK_NewRequirement_Sub
after update,insert
as
if ((select StartDate from deleted)<>(select StartDate from inserted)) and exists(select * from inserted where Stage='客户验证')
begin
insert into YK_NewRequirement(FirstSubmittedDate)
select StartDate from inserted
end
if object_id('shu','tr') is not null
drop trigger shu
go
create trigger shu on YK_NewRequirement_Sub
after insert,update
as
begin
if(YK_NewRequirement_Sub.StartDate=inserted.StartDate) and(YK_NewRequirement_Sub.Stage='客户验证')
begin
insert into YK_NewRequirement(FirstSubmittedDate)
select StartDate from inserted
end
end