有两个一样的表 a表、b表,通常只操作其中一个表 a表。我想delete a表中的记录时,同时也能delete b表的记录。a表中有个字段有唯一的值:id。当然b表也有。
我现在写的
CREATE TRIGGER trg_Delete ON [a]
--WITH ENCRYPTION
FOR DELETE
NOT FOR REPLICATION
AS
declare
@id char(12)
select @id = id from deleted
delete b where id=@id
只能是:删除a表的一条记录,同时能删除b表的同一条记录。
我希望能同时删除a表的一批记录,同时也能删除b表的一批记录
---------------------------------------------------------------
CREATE TRIGGER trg_Delete ON [a]
--WITH ENCRYPTION
FOR DELETE
NOT FOR REPLICATION
AS
delete b
from deleted d,b
where b.id=d.id
go