Robert Mahon-475361 (10/25/2010)
kasisriharsharao (10/25/2010)
Thanks for your post... If the Table has already has INTEGER type Natural Key, would you still recommend the Surrogate Key ...Read;
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=2
All of quazibubble's posts, including his later posts from another account when the first one gets banned and you'll have your answer.
Out of curiosity though, what integer natural key are you thinking?
He certainly makes some good points.
However, if you want to see the best point made, it is the one by JCamburn at 05/23/2003 : 23:19:21
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=6
He actually gets it.