Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Insert Trigger

    CREATE TRIGGER [trg_INSERT_Table1] ON [dbo].[Table1]

    FOR INSERT AS

    DECLARE @a VARCHAR(10)

    DECLARE @b-2 INT

    SET @a = (SELECT a FROM inserted)

    SET @b-2 = (SELECT b FROM inserted)

    UPDATE table1 SET c = @b-2 WHERE...

Viewing post 1 (of 2 total)