CREATE TRIGGER TR_A
ON A
FOR INSERT,DELETE,UPDATE
ASDELETE B
FROM B,DELETED D
WHERE B.KEYFIELD=D.KEYFIELDINSERT B
SELECT * FROM INSERTED
GOKEYFIELD是量个表的主键,如果是复合主键,就用AND连接。
ON A
FOR INSERT,DELETE,UPDATE
ASDELETE B
FROM B,DELETED D
WHERE B.KEYFIELD=D.KEYFIELDINSERT B
SELECT * FROM INSERTED
GOKEYFIELD是量个表的主键,如果是复合主键,就用AND连接。
on A
for insert,update,delete
as
DECLARE @TIME DATETIME
SELECT @TIME=GETDATE()
insert b
(b1,b2,b3,op,OPTIME)
select a1,a2,a3,1,@TIME from INSERTEDinsert b
(b1,b2,b3,op,OPTIME)
select a1,a2,a3,1,@TIME from DELETEDGO