Home > database >  Dear bosses, how to make the following SQL server Oracle
Dear bosses, how to make the following SQL server Oracle

Time:10-23

If the exists (select 1
The from sysobjects
Where id=object_id (' HRZL_trUpdMLArchives_Client_GG)
And type='TR)
Drop the trigger HRZL_trUpdMLArchives_Client_GG
Go


Create the Trigger [dbo] [HRZL_trUpdMLArchives_Client_GG] on [dbo] [tMLArchives_Client_GG]
For Update AS
Set NoCount On
Open - whether the trigger parameters, or does not perform the following program
If not the Exists (Select 1 From tParameter Where fNO='IsOpenTrigger' and fValue='https://bbs.csdn.net/topics/1')
Return