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')
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')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货