TR_BATCHCODETABLEFIELDCODE_INSERT_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_BATCHCODETABLEFIELDCODE_INSERT_BBNCCODETABLEIDMAP on dbo.BATCHCODETABLEFIELDCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'ab066a32-f254-43ec-8e6a-25271899daf3', ID from inserted end