TR_EVENT_UPDATE_STARTDATETIMEWITHOFFSET (Trigger)

                
                    CREATE trigger TR_EVENT_UPDATE_STARTDATETIMEWITHOFFSET on dbo.EVENT after insert,update not for replication
                    as begin
                        set nocount on;
                        
                        declare @CURRENTDATE datetime = getdate();
                        
                        if update(STARTDATE) or update(STARTTIME)
                            begin
                                update dbo.EVENT set STARTDATETIMEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(inserted.STARTDATETIME, 0),
                                        CHANGEDBYID = inserted.CHANGEDBYID,
                                        DATECHANGED = @CURRENTDATE
                                    from dbo.EVENT E inner join inserted on E.ID = inserted.ID
                            end
                        
                    end