TR_CONSTITUENCYCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_CONSTITUENCYCODE_INSERT_BBNCCODETABLEIDMAP on dbo.CONSTITUENCYCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'c5b35c5a-7ef0-47c6-aa54-7a1fdf32fda1', ID from inserted end