TR_HOLDCODE_INSERT_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_HOLDCODE_INSERT_BBNCCODETABLEIDMAP on dbo.HOLDCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'e70dd3e0-ae37-4462-9a47-4d96d25d3167', ID from inserted end