TR_CAREERLEVELCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_CAREERLEVELCODE_INSERT_BBNCCODETABLEIDMAP on dbo.CAREERLEVELCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '65a81a1f-4c0d-4db3-a5db-2557e2aea3b1', ID from inserted end