Re: NextNumbers Tables

"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 Wed Feb 12 2003 - 04:56:47 CET