use [xc]
go

create trigger xc_cfq_項目采買單
ON [dbo].[項目采買單]
After UPDATE
AS
Declare @mc as char
Declare @sl as char
Declare @cur_sl as char
Declare @xmbh as char
Declare @xmsj as char
Declare @dj as char
Declare @hj as char
Declare @sjzc as char
Declare @xxsm as char
Declare @wcqr as char
Declare @sfyfp as char
Declare @xmzj as char
Declare @kffz as char
Declare @cwfz as char
Declare @zjl as char
select @mc = sl from inserted
select @sl = sl from inserted
if not exists(select sl from [dbo].[庫存] where sl = @sl)
Begin
Insert into [dbo].[項目采買單] values (
      @mc,
      @sl,
      @xmbh,
      @xmsj,
      @dj,
      @hj,
      @sjzc,
      @xxsm,
      @wcqr,
      @sfyfp,
      @xmzj,
      @kffz,
      @cwfz,
      @zjl)
end
Else
Begin
select @cur_sl = sl from [dbo].[庫存]
Update [dbo].[庫存] set sl= (@sl + @cur_sl)
End