TR_RELATIONSHIP_INSERT_BBNCRELATIONSHIPIDMAP (Trigger)

                
CREATE trigger TR_RELATIONSHIP_INSERT_BBNCRELATIONSHIPIDMAP on dbo.RELATIONSHIP after insert not for replication
as begin
    insert into dbo.BBNCRELATIONSHIPIDMAP (RELATIONSHIPID)
        select ID from inserted
end