Tuesday, July 30, 2013

Best Method to update FK from IDENTITY(1,1) PK table after insert

would it be bad programming, and hurt my DB in the long run, to add a temporary column in my person table so the PersonSystemId goes with my insert and then i can update my PersonMapping table and then drop the temporary column in the Person table?

No comments:

Post a Comment