SQL Server Performance

Trigger problem

Discussion in 'Getting Started' started by david_bronsky, Feb 9, 2008.

  1. david_bronsky New Member

    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 advanceDavid
  2. Adriaan New Member

    Sounds like poor normalization, and looks a lot like a classroom excercise. The best cheatsheet is Books Online, which is installed as part of the SQL Server software.

Share This Page