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
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
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'reminder' AND type = 'TR')
DROP TRIGGER reminder
GO
CREATE TRIGGER reminder
ON titles
FOR INSERT, UPDATE, DELETE
AS
EXEC master..xp_sendmail 'MaryM',
'Don''t forget to print a report for the distributors.'
GO
CREATE TRIGGER TEMP
ON TEMP_TABLE
AFTER INSERT,UPDATE,DELETE
--更新
IF EXISTS(SELECT * FROM DELETED) AND EXISTS(SELECT * FROM INSERTED)
--删除
IF EXISTS(SELECT * FROM DELETED) AND NOT EXISTS(SELECT * FROM INSERTED)
--新增
IF EXISTS(SELECT * FROM INSERTED) AND NOT EXISTS(SELECT * FROM DELETED)
....
declare @dep_id int
select @dep_id=dep_id from deleted
delete employee where @dep_id=dep_idcreate trigger depidinsert on department for insert as
declare @dep_id int
select @dep_id=dep_id from inserted
insert into employee(dep_id) values(@dep_id)
DROP COLUMN COL_A没用相应的触发器