create trigger dd on a for insert as insert into b select * from inserted
create trigger dd on a alter insert as insert into b select * from inserted
还应该有个修改b.bb的语法吧???
if exists (select * from sysobjects where name='tu_a_insert' drop trigger tu_a_insert gocreate trigger tu_a_insert on a for insert as begin declare @aa 类型 if not update(aa) return select @aa=aa from inserted update b set bb=@aa where a和b的对应的条件 end
create trigger tu_a_insert on a for update as begin declare @aa int select @aa=aa from inserted update b set bb=@aa+bb end go
for insert
as
insert into b select * from inserted
alter insert
as
insert into b select * from inserted
drop trigger tu_a_insert
gocreate trigger tu_a_insert
on a
for insert
as
begin
declare @aa 类型
if not update(aa) return
select @aa=aa from inserted
update b set bb=@aa where a和b的对应的条件
end
on a
for update
as
begin
declare @aa int
select @aa=aa from inserted
update b set bb=@aa+bb
end
go