带参数触发器例子

create trigger trigger_t1 on tb_sales_info
for insert
declare @BookNo nvarchar(10),@Number int
set @BookNo=(select top1 BookNo from inserted )
set @BookNo=(select top1 Number from inserted)

begin
update tb_sales_info set StockNum=StockNum-@Number where BookNo=@BookNo
end
insert into tb_sales_info values('bkooo1', 58.00,4,'2009-9-1')