TR_TIMETABLEDAYPERIOD_UPDATE_CLASSMEETINGTEMPLATE_INUSE (Trigger)

                
                    create trigger [dbo].[TR_TIMETABLEDAYPERIOD_UPDATE_CLASSMEETINGTEMPLATE_INUSE] 
                        on [dbo].[TIMETABLEDAYPERIOD] 
                        for update
                    as begin
                        set nocount on

                        if update(TIMETABLEDAYID) or update(STARTTIME) or update(ENDTIME) 
                        begin
                            if exists(
                                    select 1
                                    from inserted
                                        inner join deleted on inserted.ID = deleted.ID
                                        inner join dbo.CLASSMEETINGTEMPLATE on inserted.ID = CLASSMEETINGTEMPLATE.TIMETABLEDAYPERIODID
                                    where inserted.TIMETABLEDAYID <> deleted.TIMETABLEDAYID
                                        or inserted.STARTTIME <> deleted.STARTTIME
                                        or inserted.ENDTIME <> deleted.ENDTIME
                                )
                            begin
                                raiserror('BBERR_TIMETABLEDAYPERIOD_CLASSMEETINGTEMPLATE_INUSE', 13, 1)
                            end
                        end 
                    end