TR_SURVEYDOWNLOADPROCESS_DELETE_KEEPBUSINESSPROCESSROW

Definition

Copy


                    create trigger TR_SURVEYDOWNLOADPROCESS_DELETE_KEEPBUSINESSPROCESSROW on dbo.SURVEYDOWNLOADPROCESS instead of delete not for replication
                    as
                    begin
                        delete SURVEYDOWNLOADPROCESS from dbo.SURVEYDOWNLOADPROCESS 
                        inner join deleted as [D] on [D].ID = SURVEYDOWNLOADPROCESS.ID 
                        where [D].ID <> 'CE06A9F5-8A55-4294-B041-90A58AC83F73';
                    end