if exists (select 1
from sysobjects
where id = object_id('HRZL_trUpdMLArchives_Client_GG')
and type = 'TR')
drop trigger HRZL_trUpdMLArchives_Client_GG
go
Create Trigger [dbo].[HRZL_trUpdMLArchives_Client_GG] on [dbo].[tMLArchives_Client_GG]
For Update AS
Set NoCount On
-- 判斷觸發器引數是否打開,否則不執行下面的程式
If not Exists(Select 1 From tParameter Where fNO = 'IsOpenTrigger' and fValue = '1' )
Return
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/31340.html
標籤:基礎和管理
