Posted by Mark D Powell on 03/09/06 03:21
J, I suspect that if you have NULL in the colum or a column of what
should be the natural key to a table that you have bad data or a
non-normalized table.
Fixing bad data is usually easier than fixing bad design.
Adding a surrogate key will do nothing to protect the integrity of the
business data in the columns in question.
Good luck
-- Mark D Powell --
Navigation:
[Reply to this message]
|