TR_DENOMINATIONCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_DENOMINATIONCODE_INSERT_BBNCCODETABLEIDMAP on dbo.DENOMINATIONCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '84e626ab-0e5a-498b-8f04-cc8d93c5dbd3', ID from inserted end