CREATE TRIGGER dbo.haschanged --Any Trigger name
ON [table]
after UPDATE
AS
BEGIN
SET nocount ON;
DECLARE @Old VARCHAR(100),
@New VARCHAR(100)
SELECT @New = i.[col]
FROM inserted AS i
SELECT @Old = d.[col]
FROM deleted AS d
IF @New <> @Old
BEGIN
--Field was changed
END
ELSE
BEGIN
--Field was not changed
END
END
OR
CREATE TRIGGER dbo.haschanged --Any Trigger name
ON [table]
after UPDATE
AS
BEGIN
IF UPDATE (col)
BEGIN
--Field was changed
END
ELSE
BEGIN
--Field was not changed
END
END
No comments:
Post a Comment