On 4/6/06, Bas Scheffers <[EMAIL PROTECTED]> wrote: > Mark Aufflick said: > > do show disturbingly similar philosophies - like making NULL = NULL by > > default because many clients with poorly trained developers asked for > I recon that's the only one! (and I still don't see why this is such a bad > thing) My problem with MySQL isn't this "simplification", it's the > inconsistencies. (apart from other "known issues") Sybase is very > consistent in what it does, even if you find it's not the way _you_ would > like it to do things.
I feel a good old fashioned usenet style flame war coming on =) In Sybase, NULL matches NULL in a search clause (by default - as established), but NULL will never match anything (not even itself) in a join ( http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/13175 ). That doesn't sound very consistent! > > I do find the T-SQL syntax quite cumbersome too, but I suspect that is > > more personal preference than anything else. > It could very well be what you grew up on; I used T-SQL before anything > else and just hate PL/SQL! You are probably correct. (Although I grew up on Applesoft basic and I don't like VB!) Should we call a truce? ;) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.