CREATE TRIGGER [id1-id2] ON [dbo].[Table1] after INSERT AS IF UPDATE (id1) insert into [bdo].[Table2] (id2) select * from inserted是这样吗? 我试了怎么不行?
CREATE TRIGGER [id1-id2] ON [dbo].[Table1] after INSERT AS IF UPDATE (id1) insert into [dbo].[Table2] (id2) select id1 from inserted insert into [dbo].[Table3] (id3) select id1 from inserted成功,不过还是很多问题
after INSERT
AS
IF UPDATE (id1)
insert into [bdo].[Table2] (id2)
select *
from inserted是这样吗?
我试了怎么不行?
after INSERT
AS
IF UPDATE (id1)
insert into [dbo].[Table2] (id2)
select id1
from inserted
insert into [dbo].[Table3] (id3)
select id1
from inserted成功,不过还是很多问题