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')
带参数触发器例子
最新推荐文章于 2021-04-06 01:22:13 发布