TR_DECLARATIONSOURCECODE_INSERT_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_DECLARATIONSOURCECODE_INSERT_BBNCCODETABLEIDMAP on dbo.DECLARATIONSOURCECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'f4caf9b9-e0c7-4115-8c33-4d4a515d42c0', ID from inserted end