TR_DESIGNATION_INSERT_BBNCDESIGNATIONIDMAP (Trigger)

        
                CREATE trigger TR_DESIGNATION_INSERT_BBNCDESIGNATIONIDMAP on dbo.DESIGNATION after insert not for replication
                as begin
                    insert into dbo.BBNCDESIGNATIONIDMAP (DESIGNATIONID)
                        select ID from inserted;
                end