Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567

UNIQUE constraint Expand / Collapse
Author
Message
Posted Friday, December 28, 2012 12:35 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 8,679, Visits: 9,205
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
Post #1401015
Posted Friday, January 11, 2013 1:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 2,840, Visits: 3,867
Oh my, why is this question still wrong in January?!?

Best Regards,
Chris Büttner
Post #1405801
Posted Friday, January 11, 2013 5:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 11, 2014 6:34 PM
Points: 157, Visits: 290
i couldn't fight back to those who said the question is wrong Chris

Gopi
Post #1405916
Posted Friday, January 11, 2013 5:11 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 8,679, Visits: 9,205
Christian Buettner-167247 (1/11/2013)
Oh my, why is this question still wrong in January?!?


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
Post #1405919
Posted Tuesday, January 15, 2013 1:36 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 8:54 PM
Points: 606, Visits: 151
+1
Post #1407473
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse