Need help creating Triggers

  • thiruna

    SSC Enthusiast

    Points: 105

    friends,

    i have come up with one more question to clarify.....

    i have got 3 tables machines, beverages and machine_beverages...

    1. machine table has got machine_id, machine_name etc....

    2. beverage table has got beverage_id, beverage_name

    3. machine_beverage table has got machine_id, beverage_id, bev_key, gram_settings etc....

    Now i have done the following programming for the data entry in 3 tables....

    a. A data entry page for beverage table using ASP and stored procedure(SQL)

    b. A data entry page for machines tables. This page receives the machine details and beverage settings for that machine and save it in corresponding tables.

    if there are 5 beverages, it adds 5 entries in machine_beverage table when adding new machine to the machines tables.

    In future, if new beverage gets added to beverage table, i want the SQL server to add beverage gram settings and beverage key (default to 0) in machine_beverage table for all the machines present in that.

    I know this could be done using Trigger statement for the beverage table after every new insert.

    could u please tell me how this trigger could be written

    many thanks in advance

    thiruna@vsnl.com

  • jwiner

    SSCrazy

    Points: 2241

    Try and take a stab at it first...post the code you have and we can go from there.

  • thiruna

    SSC Enthusiast

    Points: 105

    ok i will do that and come back...

    thanks

    thiru

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply