create trigger tri_aa on aaa for update,insert,delete as
declare @aid int,@bid int,@aname varchar(20),@aage numeric
if insert
begin
select @aid=aid from inserted
select @aname=aname from inserted
select @aage=aage from inserted
insert into bbb values(@aid,@aname,@aage,'新增')
end
create trigger tri_aab on aaa for update,insert,delete as
declare @aid int,@bid int,@aname varchar(20),@aage numeric
if delete
begin
select @aid=aid from deleted
update bbb set operation='删除' where bid=@aid
end
create trigger tri_aa on aaa for update,insert,delete as
declare @aid int,@bid int,@aname varchar(20),@aage numeric
if update
begin
select @aid=aid from deleted
select @bid=aid from inserted
select @aname=aname from inserted
select @aage=aage from inserted
update bbb set bid=@bid,bname=@aname,bage=@aage,opration='编辑后' where bid=@aid
end
CREATE TABLE A
(A VARCHAR(250),
B VARCHAR(250),
C VARCHAR(250))
CREATE TABLE B
(A VARCHAR(250),
B VARCHAR(250),
C VARCHAR(250),
OPERATION VARCHAR(250))
CREATE TRIGGER A_INS
ON A
FOR INSERT
AS
DECLARE
@A VARCHAR(250),
@B VARCHAR(250),
@C VARCHAR(250)
SELECT @A = A,@B = B,@C = C FROM INSERTED
INSERT INTO B VALUES(@A,@B,@C,'新增')
CREATE TRIGGER A_UPD
ON A
FOR UPDATE
AS
DECLARE
@A VARCHAR(250),
@B VARCHAR(250),
@C VARCHAR(250)
SELECT @A = A,@B = B,@C = C FROM INSERTED
INSERT INTO B VALUES(@A,@B,@C,'编辑后')
SELECT @A = A,@B = B,@C = C FROM DELETED
INSERT INTO B VALUES(@A,@B,@C,'编辑前')
CREATE TRIGGER A_DEL
ON A
FOR DELETE
AS
DECLARE
@A VARCHAR(250),
@B VARCHAR(250),
@C VARCHAR(250)
SELECT @A = A,@B = B,@C = C FROM DELETED
INSERT INTO B VALUES(@A,@B,@C,'删除')