TR_DESIGNATION_INSERTUPDATE_NAME

Trigger Definition

				
						create trigger [dbo].[TR_DESIGNATION_INSERTUPDATE_NAME] on [dbo].[DESIGNATION]
							after insert, update
							not for replication
							as
							begin
								set nocount on;
								
								if (update(DESIGNATIONLEVEL1ID)
									or update(DESIGNATIONLEVEL2ID)
									or update(DESIGNATIONLEVEL3ID)
									or update(DESIGNATIONLEVEL4ID)
									or update(DESIGNATIONLEVEL5ID))
								begin
									declare @IDS UDT_GENERICID;
									insert into @IDS
									select ID from inserted
								
									exec dbo.USP_DESIGNATION_SETNAME @IDS
								end
							end