doubt in trigeers

Question

in table i have following three fields

ID Name PurchaseAmount

using trigeers i want to show error message.

customer have to puchase the goods minium 200 amount.

in puchaseamount filed if i type 150 the error message shows.you have to buy goods minium 200 rs sorry.

how to do using trigeers.

Senthilkumar · Answer

Hi You need to use the following trigger. CREATE TRIGGER Tr_Purchase_AmountCheck ON Purchase --Table names come here AFTER INSERTUPDATE AS BEGIN SET NOCOUNT ON DECLARE @PurchaseAmount INT SELECT @PurchaseAmount = PurchaseAmount FROM INSERTED IF(@PurchaseAmount BEGIN PRINT ' >' ROLLBACK END END If this help you then mark it as Accepted Answer