CREATE TRIGGER Soustraction_Stock
ON Commande
AFTER INSERT
AS
BEGIN
DECLARE @Id_Stock int, @Quantite int
SELECT @Id_Stock = Id_stock FROM INSERTED
SELECT @Quantite = Quantite FROM INSERTED
UPDATE Stock
SET Quantite = Quantite-@Quantite
WHERE Id_Stock = @Id_Stock
END