Use [Cdm]go/** * * * Object:trigger [dbo]. [Updateakisflight] Script DATE:2018/6/14 16:43:29 * * * * **/SET ansi_nulls ongoset quoted_identifier ongoalter TRIGGER [dbo]. [Updateakisflight] on [dbo]. [Flightwarntime] For Insert,deleteas BEGINif(Exists (Select 1 frominserted) and NOT EXISTS (Select 1 fromdeleted)) Begin declare @TwoCode nvarchar ( -), @FlightNum nvarchar ( -), @ThreeCode nvarchar ( -), @Etd datetime, @FlightIdint, @Calsign nvarchar ( -), @IDint Select@TwoCode =twocode, @FlightNum =flightnumber, @Etd = Etd, @ID = ID frominsertedSelect@ThreeCode =code3 fromCompany with (NOLOCK)whereCode2=@TwoCodeif@ThreeCode isNotNULLbeginSet@[email protected]+@FlightNumif@FlightNum isNotNULLbegin UPDATE [dbo]. [Flightwarntime]Set[Email protected]whereId=@ID Endif@Etd isNotNULLbeginSelect@FlightId =flightid from[Akis]. [dbo]. [Validflight] with (NOLOCK)where[email protected] and ABS (DATEDIFF (minute,etd, @Etd)) <= -and depaddrname='ZHCC'Endif@FlightId isNotNULLbegin UPDATE [dbo]. [Flightwarntime]Set[Email protected]whereId=@ID end End EndEnd
Sql-server trigger that matches a field in another table according to the criteria