求 一sql 触发器
CREATE TRIGGER [DeleteA] ON [dbo]。[A]
FOR DELETE
AS
delete from b where [name] in (selece [name] from deleted)
CREATE TRIGGER [InsertA] ON [dbo]。 [A]
FOR Insert
AS
insert b([name]) select [name] from inserted
CREATE TRIGGER [UpdateA] ON [dbo]。 [A]
FOR Update
AS
delete from b where [name] in (sel...全部
CREATE TRIGGER [DeleteA] ON [dbo]。[A]
FOR DELETE
AS
delete from b where [name] in (selece [name] from deleted)
CREATE TRIGGER [InsertA] ON [dbo]。
[A]
FOR Insert
AS
insert b([name]) select [name] from inserted
CREATE TRIGGER [UpdateA] ON [dbo]。
[A]
FOR Update
AS
delete from b where [name] in (selece [name] from deleted)
insert b([name]) select [name] from inserted
。
收起