How to check a column in a table ,value, update

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

CREATE TRIGGER tr_Employees_U on Employees FOR UPDATE AS

    IF UPDATE(lastname)

    BEGIN

        SELECT 'LastName is updated'

        RETURN

    END

GO

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

CREATE TRIGGER tr_Employees_U on Employees FOR UPDATE AS

    IF ( DELETED.LastName != INSERTED.LastName)              -- Checking for new value update 

    BEGIN

        SELECT "LastName is updated with new value'

    END

GO

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif