2 Jul 2013 by Radhadeep12
Try thisCREATE TABLE Product(Id INT, Stock INT,UnitsStock INT)INSERT Product VALUES(1,100,200),(2,200,400),(3,300,600),(4,400,800)GOCREATE TRIGGER trUnitStocks ON ProductFOR UPDATEASBEGIN DECLARE @UnitStocks INT SET @UnitStocks = (SELECT I.UnitsStock FROM INSERTED...