?? 項目采買單觸發器.txt
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -