復制代碼 代碼如下:

IF EXISTS(SELECT * FROM sysobjects
WHERE AND TYPE='TR')
DROP TRIGGER tr_Users_OnUpdate
GO --這里呢創建觸發器與存儲過程類似（都是DDL）
--先判斷如否存在同名觸發器就刪除然后重建
CREATE TRIGGER tr_Users_OnUpdate
ON Users FOR UPDATE
AS PRINT ‘Users表已發生修改'
GO

復制代碼 代碼如下:

--添加留言的觸發器
IF EXISTS(SELECT name FROM sysobjects WHERE AND TYPE='TR')
DROP TRIGGER tr_LeaveWord_Add
GO
CREATE TRIGGER tr_LeaveWord_Add
ON WordInfo FOR INSERT
AS UPDATE UserInfo SET LeaveCount=LeaveCount+1
WHERE UserID=(SELECT TOP 1 UserID FROM Inserted)
GO