Home Forums Article Discussions Article Discussions by Author Discuss content posted by Deepthi Viswanathan Nair How can I add custome tag(Inserted, Updated, deleted) into column of status based on Insert, Update and Delete operation. RE: How can I add custome tag(Inserted, Updated, deleted) into column of status based on Insert, Update and Delete operation.

  • June 4, 2013 at 10:13 am

    #1621036

    maybe soemthing like this might help?

    you just need to test for the existence of any data int he INSERTED or DELETED virtual tables

    CREATE TRIGGER TR_WHATEVER_NOTIFICATIONS

    ON WHATEVER FOR INSERT,UPDATE,DELETE

    AS

    BEGIN

    SET NOCOUNT ON

    declare @optype tinyint = 0;

    if exists (select * from INSERTED) set @optype = @optype + 1

    if exists (select * from DELETED) set @optype = @optype + 2

    --use soemthing like this?

    /*

    case @optype

    when 1 then 'New row inserted into ConfigSet table in XXXXXX'

    when 2 then 'Row deleted from ConfigSet table in XXXXXX'

    when 3 then 'Row modified in ConfigSet table in XXXXXX'

    else 'This should never happen'

    end ;

    */

    END --TRIGGER

    GO

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!