Subject | Re: Need advice |
---|---|
Author | jasajona |
Post date | 2005-10-26T07:48:57Z |
Something like this:
CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
AFTER
INSERT
AS
BEGIN
INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1+OLD.FIELD2);
END
How to do it right and fastest for execution?
CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
AFTER
INSERT
AS
BEGIN
INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1+OLD.FIELD2);
END
How to do it right and fastest for execution?