对表进行insert:在inserted表中有刚增加的记录。
对表进行update:在inserted表中有刚更新的记录,在delete表中有更新前的记录。
对表进行delete:在delete表中有刚删除的记录。
--for example
create trigger tri1 on a
for insert
as
--在A表中每插入一条记录时,把f1的值加1
update a set f1=inserted.f1+1 from inserted where a.主键=inserted.主键
USE pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'reminder' AND type = 'TR')
DROP TRIGGER reminder
GO
CREATE TRIGGER reminder
ON titles
FOR INSERT, UPDATE
AS RAISERROR (50009, 16, 10)
GO