out触发器.txt

简单邮电信息管理

CREATE TRIGGER insert_out ON [dbo].[Out_Info] 
FOR INSERT
AS
declare @o_id varchar
declare @o_size varchar
declare @o_num int
declare @o_date datetime
declare @s_id varchar
declare @s_size varchar
declare @s_quan int

select    @o_id=inserted.STOR_ID,
	@o_size=inserted.S_Size,
	@o_num=inserted.Num,
	@o_date=inserted.O_Date
from inserted

select	@s_id=Stor_Info.ID,
	@s_size=Stor_Info.S_Size,
	@s_quan=Stor_Info.Quantity
from Stor_Info
where Stor_Info.ID=@o_id
	and Stor_Info.S_Size=@o_size

if exists
(select Stor_Info.ID from Stor_Info
where Stor_Info.ID=@o_id
	and Stor_Info.S_Size=@o_size)

	update Stor_Info
		set Quantity=@s_quan-@o_num
	where Stor_Info.ID=@o_id
		and Stor_Info.S_Size=@o_size