How to create trigger only when successful updatation of a column value happens.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ron Moses » How to create trigger only when successful...

How to create trigger only when successful updatation of a column value happens.

Rate Topic

Display Mode

Topic Options

Author

Message

subapriya

Posted Thursday, December 03, 2009 3:45 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 3:40 AM
Points: 59, Visits: 15

CREATE TABLE TriggerTest (Value int)
GO
INSERT INTO TriggerTest VALUES (1)
GO

CREATE TRIGGER tr_TriggerTest ON TriggerTest
AFTER UPDATE AS
BEGIN
SET NOCOUNT ON;
[color=red]IF UPDATE(Value)
PRINT 'The trigger fired' [/color]
ELSE
PRINT 'The trigger did not fire'
END
GO

--Set Value equal to itself
UPDATE TriggerTest SET Value = Value
--SELECT * FROM TriggerTest
DROP TABLE TriggerTest

Post #828036

« Prev Topic | Next Topic »

Permissions