TR_MERCHANDISEPRODUCTNOTETYPECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_MERCHANDISEPRODUCTNOTETYPECODE_INSERT_BBNCCODETABLEIDMAP on dbo.MERCHANDISEPRODUCTNOTETYPECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'f19fc607-9990-46e1-bd95-3ff728e2c6ab', ID from inserted end