I have a table where one of the fields is defined like
[barCodeID] int IDENTITY(1, 1) NOT NULL - so the value in this column is generated automatically.
What I want is, after each INSERT, to write this automatically generated value to another table. The simplest would be to do it with an after insert trigger, but don't know how. How to refer to a value from the last added record in a trigger?
View Complete Post