Trigger problem

  • I have question about TRIGGERS.

    I have (4 example) VEHICLE_TABLE with VEHICLE_TYPE column and CAR_TABLE and TRUCK_TABLE also.

    I need TRIGGER for INSERT/UPDATE/DELETE who well read value of VEHICLE_TYPE column in VEHICLE_TABLE and if value of VEHICLE_TYPE is CAR he will execute

    INSERT/UPDATE/DELETE on CAR_TABLE and if value of VEHICLE_TYPE column in VEHICLE_TABLE is TRUCK he will execute INSERT/UPDATE/DELETE on TRUCK_TABLE.

    I am using SQL Server 2005.

    Is there any idea how can I solve this problem.

    Thanks in advance

    David

  • This sounds like homework. Please show some effort in creating a trigger and using basic logic. This isn't that hard and we'll help point you in the right direction, but you have to make an effort.

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

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