SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


UNIQUE constraint


UNIQUE constraint

Author
Message
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26047 Visits: 12499
Hugo Kornelis (12/21/2012)
Hi Tom,

I don't know what happened when you wrote that - I have never seen that kind of language from you before! "intransigence" (had to look that word up in a dictionary) ... "apparently brainless" ... "stupidity" ... not your style at all! Luckily, you targeted the up-voters of that connect item, not the submitter, so I don't need to feel offended. ;-)

Maybe I was remembering the period from 1985 to 1992, when I was young (¿¡when did I start calling my 40s young!?) and naïve and thought that ANSI would want the technically best standard instread of the best profits for American companies. But then came 1986 and 1992. I remember people I worked with back then (some from universities, some from Groupe Bull, some from INRIA, and various others) agreeing that it wouldn't possible to get anything into SQL2 (what we called the standard being worked on at that time, which eventually necame sql1992) unless it had already been implemented by IBM or by Oracle. I didn't keep my illusions. Really I should have lost them years before, because I had been bitten by the updowngrade from a sensible version of Fortran to ASA (or was it already USASI? anyway, what is now called ANSI) Fortran66, which was basically Fortran IV (and was often incorrectly called Fortran IV) with the bits that hadn't been implemented by all of the big boys left out (Fortran IV was of course bad enough, but ASA can't be blamed for that, it wasn't involved in that "standard") when Fortran66 hit me in 1967.

But SQL standardisation wasn't all bad - it did have NULL in it, despite not all American RDBMS implementations of the time time having NULL. Just think what life would have been like if it had followed what RTI had implemented under the direction of Stonebraker and Wong; we would have had no NULLs, just the sort of insane default value system so loudly advocated by Date. RTI's INGRES/QUEL system at that time used default values; and the default value for all numeric types was zero, so one couldn't know whether a zero meant "zero" or "value not known". This prompted Codd to write "I consider the number zero to be far too valuable in its normal role in all kinds of business activities", which amused me greatly when first I read it.

Tom

Christian Buettner-167247
Christian Buettner-167247
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: General Forum Members
Points: 5301 Visits: 3889
Oh my, why is this question still wrong in January?!? Sad

Best Regards,

Chris Büttner
Gopi S
Gopi S
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 325
i couldn't fight back to those who said the question is wrong Chris Blink

Gopi
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26047 Visits: 12499
Christian Buettner-167247 (1/11/2013)
Oh my, why is this question still wrong in January?!? Sad


That's a good question. These days it seems usual that something this bad is corrected quite quickly. Don't know why this one hasn't been.

Tom

asifkareem
asifkareem
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 151
+1
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search