Re: Surrogate Key vs Production Key

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097431960.682256_at_yasure>...
> > Arguments, you want? Already supplied a few. Here is more:
>
> I don't think you truly have an argument as I can not think of a single
> time in the last 5 years I have found a reason to update (modify) a
> natural key. I think you've been eating too much red herring ... try
> salmon instead.

I guess you haven't worked for a business that had a customer buy another customer. Then some of the users want the keys updated so they can compare current and past sales, and some don't because they used to be different customers under different salespeople.

jg

--
@home.com is bogus.
http://www.empowered.org/