TR_EDUCATIONALREASONLEFTCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_EDUCATIONALREASONLEFTCODE_INSERT_BBNCCODETABLEIDMAP on dbo.EDUCATIONALREASONLEFTCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'df547dfd-6192-4b9f-a5a7-4cc87f95fc4a', ID from inserted end