create trigger triggername on tb
for update
as
if update(续借)
begin
update t1
set t1.日期=dateadd(month,2,t1.日期)
from tb t1,inserted t2
where t1.id=t2.id
end
create trigger triggername on tb
for update
as
if update(续借)
begin
update t1
set t1.日期=dateadd(month,2,t1.日期)
from tb t1,inserted t2
where t1.id=t2.id
end