TR_VOLUNTEERSPECIALNEEDCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_VOLUNTEERSPECIALNEEDCODE_INSERT_BBNCCODETABLEIDMAP on dbo.VOLUNTEERSPECIALNEEDCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '68c14b36-ff1f-4b89-a687-9da61ce48d1a', ID from inserted end