Results 1 to 2 of 2

Thread: trigger

  1. #1
    Join Date
    Dec 1969

    Default trigger

    I have two tables T1, T2.<BR><BR>When a row is inserted into T1, I want that row to go into T2 also. This was easy in Oracle...... <BR><BR>CREATE OR REPLACE TRIGGER a_trigger<BR>AFTER INSERT ON T1<BR> BEGIN<BR> INSERT INTO T2 (column_name)<BR> VALUES (:new.column_name)<BR> END<BR><BR>How do you do this in SQL Server 7<BR><BR>Thanks,<BR><BR>steve

  2. #2
    Ed Guest

    Default RE: trigger

    Look under TRIGGER in the SQL Books On-line. There is extensive documentation there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts