TR_STATEHOUSEDISTRICTCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_STATEHOUSEDISTRICTCODE_INSERT_BBNCCODETABLEIDMAP on dbo.STATEHOUSEDISTRICTCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'dabf0890-efa6-469b-8ead-2dee61abe3a2', ID from inserted end