Viewing post 1 (of 2 total)
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...
April 14, 2004 at 1:47 am
#502665