CREATE TRIGGER [dbo].[Discount]

ON [dbo].[Product]

INSTEAD OF INSERT

AS

Declare @disc int;

Declare @line int;

Declare @pdid as varchar(10);

BEGIN

select @disc = i.DiscPercentage from inserted i

select @line = i.LineNumber from inserted i

select @pdid = i.ProdId from inserted i

IF (@disc>18 and @pdid between 1000 and 2000)

RAISERROR(N'Please Type Correct Discount',16,1);

ROLLBACK;

END