Unnamed

DROP TRIGGER carrier_routesGOCREATE TRIGGER carrier_routesON RouteFOR INSERT, UPDATEAS        DECLARE @CarrierCount int         IF @@rowcount > 0 AND UPDATE(CarrierID)                BEGIN                        SET @CarrierCount = (SELECT count(Route.CarrierID)                                             FROM Route, Inserted                                             WHERE Route.CarrierID = Inserted.CarrierID)                        IF @CarrierCount > 3                                BEGIN                                        ROLLBACK TRANSACTION                                        RAISERROR       ('A carrier cannot have more than 3 routes', 16, 1)                                END                  END        ELSE                                BEGIN                                        PRINT 'Carrier has a new route'                                END