Professional Web Applications Themes

Using Trigger to populate another table - Microsoft SQL / MS SQL Server

Hi all, I have two tables tbl_A and tbl_B. Table Definitions: tbl_A (field_1, field_2, field_3) tbl_B (field_1, field_2) I would like to populate tbl_B when a record is inserted into tbl_A. Note that tbl_A.field_1 = tbl_B.field_1 and tbl_A.field_2 = tbl_B.field_2 . How do I write a trigger on tbl_A to get the corresponding record inserted into tbl_B? Regards June........

  1. #1

    Default Using Trigger to populate another table

    Hi all,
    I have two tables tbl_A and tbl_B.
    Table Definitions:
    tbl_A (field_1, field_2, field_3)
    tbl_B (field_1, field_2)
    I would like to populate tbl_B when a record is inserted into tbl_A.
    Note that tbl_A.field_1 = tbl_B.field_1 and tbl_A.field_2 =
    tbl_B.field_2 .

    How do I write a trigger on tbl_A to get the corresponding record
    inserted into tbl_B?

    Regards
    June.....
    June Guest

  2. #2

    Default Re: Using Trigger to populate another table

    Try

    Create trigger tbl_AIns on tbl_A
    for Insert as
    begin
    INSERT tbl_B
    Select field_1
    , field_2
    from INSERTED
    End

    HTH,
    Srinivas Sampangi


    "June Moore" <com.au> wrote in message
    news:google.com... 


    sampangi Guest

  3. #3

    Default Re: Using Trigger to populate another table

    Hello June !

    Try this

    The statement in the trigger is:

    Insert into table2
    Select field_1,field_2 from inserted

    Jens Süßmeyer.

    "June Moore" <com.au> schrieb im Newsbeitrag
    news:google.com... 


    Jens Guest

  4. #4

    Default Using Trigger to populate another table

    CREATE TRIGGER trigger1
    ON UPDATE, INSERT
    AS
    INSERT INTO tbl_B
    SELECT * FROM INSERTED /*inserted is a temp table
    containg the inserted information */
    GO
     
    into tbl_A. 

    corresponding record 
    Graham Guest

Similar Threads

  1. Select Into and Trigger on Destination table....
    By Rog in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: April 16th, 05:29 PM
  2. Replies: 2
    Last Post: May 1st, 02:33 PM
  3. Auto populate a field in a form from another table
    By Sandra Daigle in forum Microsoft Access
    Replies: 0
    Last Post: August 1st, 01:08 AM
  4. Trigger on v$sql catalog table
    By Jim Kennedy in forum Oracle Server
    Replies: 2
    Last Post: July 11th, 01:02 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139