27,582
社区成员




CREATE TRIGGER tr_aaaa ON dbo.a
AFTER UPDATE, INSERT
as
begin
IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)
BEGIN
SELECT inscnt=COUNT(*) FROM inserted
end
ELSE
BEGIN
SELECT inscnt=COUNT(*) FROM INSERTED
SELECT delcnt=COUNT(*) FROM deleted
end
END
create trigger tr_test on users
after insert,update
as
BEGIN
IF EXISTS
(
SELECT 1 FROM DELETED
)
BEGIN
insert into usersBackup(user_id,user_name,user_age,user_tel,user_address,backupdate)
select user_id,user_name,user_age,user_tel,user_address,getdate()
from INSERTED A
INNER JOIN DELETED D
ON A.USER_ID = B.USER_ID
WHERE a.user_tel <> b.user_tel OR a.user_address <> b.user_address
END
ELSE
BEGIN
insert into usersBackup(user_id,user_name,user_age,user_tel,user_address,backupdate)
select user_id,user_name,user_age,user_tel,user_address,getdate()
END
end