TR_SPROPPCHILDCONDITIONCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_SPROPPCHILDCONDITIONCODE_INSERT_BBNCCODETABLEIDMAP on dbo.SPROPPCHILDCONDITIONCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'a5e5764f-29e5-4395-9a6b-d1a180baa22f', ID from inserted end