Loading

doubt in trigeers

14y1.4kC#

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi,

You need to use the following trigger.

CREATE TRIGGER Tr_Purchase_AmountCheck
ON Purchase --Table names come here
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON
DECLARE @PurchaseAmount INT
SELECT @PurchaseAmount = PurchaseAmount FROM INSERTED
IF(@PurchaseAmount < 200)
BEGIN
PRINT '<< you have to buy goods minium 200 rs sorry...>>'
ROLLBACK
END
END

If this help you then mark it as "Accepted Answer"