create trigger [dbo].[Tig_dfMES_Insert]
on [dbo].[dfMES] after insert --插入型別
as
declare @vis varchar(8)
declare @newvid varchar(20)
--如果插入VID碼為慷訓者NULL并且VIN碼不為空。
if(((select VID碼 from inserted)='' or (select VID碼 from inserted) is NULL) and (select VIN碼 from inserted)!='' and (select VIN碼 from inserted) is not NULL)
begin
SET @vis= (select right(VIN碼,8) from inserted) --得到后8位VIS
set @newvid = (select TOP 1 VID碼 from dbo.dfmes_bak WHERE VIN碼 like '%'+@vis)--獲取VID碼
UPDATE dfMES SET VID碼=@newvid WHERE VID碼=(SELECT VID碼 FROM inserted)--更新陳述句
end
else
begin
insert into dbo.dfmes_bak select * from inserted--插入表資料
end
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/76745.html
標籤：其他數據庫
上一篇：vfp程式點查詢按鈕，系統就卡頓好久后顯示_null錯誤。跪求高手幫忙解決
下一篇：請教：如何同一實體下跨庫訪問表？