After Update Trigger

Question

0.00/5 (No votes)

See more:

i made an stored proc

SQL

ALTER proc [dbo].[MakeOrder]
@barcode varchar(50),
@packs int ,
@units int,
@Eid int 
as
begin

insert into Orders (Barcode,Price,PacksQty,UnitQty)
values (@barcode,dbo.GetOrderPackPrice(@packs,@barcode)+dbo.GetOrderUniPrice(@units,@barcode),@packs,@units)

insert into OrderDetails(Eid,Date)
values (@Eid,GETDATE())

update Product
set Stock = Stock-@packs , UnitsStock = UnitsStock-@units where BarCode=@barcode

end

and i want to make after update trigger to check the value of UnitsStock Column After Update If it 0 do something else do another thing

Posted 2-Jul-13 4:10am

Muhammed Salah

Add a Solution

2 solutions

Solution 1

Follow link below

Triggers -- Sql Server[^]

Posted 2-Jul-13 6:15am

Mahesh Bailwal

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Radhadeep12 · Accepted Answer · 2013-07-02T06:27:00

Try this

CREATE TABLE Product(Id INT, Stock INT,UnitsStock INT)
INSERT Product VALUES(1,100,200),(2,200,400),(3,300,600),(4,400,800)
GO

CREATE TRIGGER trUnitStocks ON Product
FOR UPDATE
AS
BEGIN
    DECLARE @UnitStocks INT
    SET @UnitStocks = (SELECT I.UnitsStock FROM INSERTED I)
    
    IF @UnitStocks = 0
       PRINT 'When unitstocks 0'
       --Your code--
    ELSE
       PRINT 'When unitstocks is not 0'
       --Your code--   
END
GO
UPDATE Product SET UnitsStock = 100 WHERE Id = 2

Result:-

When unitstocks is not 0
(1 row(s) affected)

After Update Trigger

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

After Update Trigger

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us