Triggers Update SQL Server

Question

How Create Trigger For Update Items in Invoice and decrement in Table Items

Nitesh Luharuka · Answer

The below trigger will run whenever an item is updated on Invoice table. However the exact implementation depend on your table structure. CREATE TRIGGER trgAfterUpdate ON [dbo].[Invoice] FOR UPDATE AS declare @ItemID int; declare @ItemCnt int; select @ItemID = i.ItemID from inserted i; select @ItemCnt = i.Itemcnt from inserted i; UPDATE Items SET ItemStock = ItemStock-@ItemCnt WHERE ItemID = @ItemID GO

Jignesh Trivedi · Answer

hi like CREATE TRIGGER trg1 ON tableName UPDATE AS BEGIN // write here TSQL Select * from table END also refer below link for more detail http://msdn.microsoft.com/en-us/library/ms189799.aspx hope this will help you.

Anupam Singh · Answer

Hi Refer this l ink will definitely help you.