Re: SQL Humor

On Fri, 19 Aug 2005 14:17:26 -0700, Gene Wirchenko wrote:

>On Fri, 19 Aug 2005 22:37:45 +0200, Tom Ivar Helbekkmo
><tih_at_hamartun.priv.no> wrote:
>
>[snip]
>
>>Of course, the member number has no physical reality, and it will be
>>an automatically assigned serial number (without reuse of defunct
>>numbers when people quit or die) -- generally, it seems to be what you
>>rant against.
>
> No, it is when the number is referring to how the data is
>physically stored. If the number is a record number or an address or
>other such, then it ties your data to the physical implementation. A
>member number (if used just as that) would not do that.

Hi Gene,

Unless I am missing the context here, Tom was talking about surrogate keys generated in MS SQL Server by the IDENTITY property.

And there is no relation between IDENTITY and physical storage.

Best, Hugo

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)