Re: NextNumbers Tables

From: Jason W. Paul <nobody_at_nowhere.com>
Date: Tue, 11 Feb 2003 22:56:47 -0500
Message-ID: <3e49a949$0$99441$a04e5680@nnrp.fuse.net>

"stu" <smcgouga_at_nospam.co.uk> wrote in message news:b28ims$phi$1$8302bc10_at_news.demon.co.uk... [snip]
> Why? My uni teacher used to say always use a surrogate key. It stops you
> from duplicating keys later. What advantages does it have over using IDs?

Fire your uni "teacher" or apply to a different school!

"Always" is pretty harsh. There are times (to the dismay of the "theorists" in this group) where they do actually make sense -- but to use them "always" is rather foolish. If your "teacher" can't explain why then you need to drop the class and wait 'til someone with half a brain instructs the class. Received on Tue Feb 11 2003 - 21:56:47 CST