Supprimer un message
Jean-Christophe
Voilà, j'ai trouvé
CREATE TRIGGER MonTrigger
ON Ventes
FOR INSERT
AS
BEGIN
IF (SELECT prix FROM inserted) > 100
UPDATE Vendeurs SET ventes = (SELECT ventes FROM Vendeur WHERE id =(SELECT Vendeur from inserted) + 1) WHERE id = (SELECT Vendeur from inserted)
END
\o/
edit : Merci Kort
CREATE TRIGGER MonTrigger
ON Ventes
FOR INSERT
AS
BEGIN
IF (SELECT prix FROM inserted) > 100
UPDATE Vendeurs SET ventes = (SELECT ventes FROM Vendeur WHERE id =(SELECT Vendeur from inserted) + 1) WHERE id = (SELECT Vendeur from inserted)
END
\o/
edit : Merci Kort