22,300
社区成员




create trigger tru_ta1
on ta1
for update
as
begin
if exists(select 1 from ta2,inserted where ta2id=taid and ta2ysh < tasl)
rollback
else
update ta2 set ta2sl=tasl
from inserted where ta2id=taid
end
create trigger triggername on tablename
for insert |delete|update
as
begin
end