Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL Humor

Re: SQL Humor

From: Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo>
Date: Sat, 20 Aug 2005 00:58:40 +0200
Message-ID: <2uocg197fukt4flg5nkfqmblfrikdk88i8@4ax.com>


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)
Received on Fri Aug 19 2005 - 17:58:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US