| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> Few servers are fully compliant, but ****, they could at least get transactions right. That's like the most critical feature.
<1> Halo_Four: Heck, look how longi t took them to even bother supporting transactions at all.
<0> Sure, because the underlying table system was clueless about it, and still is. Someone had to hand them Inno.
<2> what do you work in a bookstore or something i never have to do transactions
<0> Uh, stores need them the most.
<0> Money is involved.
<1> Never have to xdo transactions?
<1> hahahaha
<1> Oh god.
<2> well i don't
<0> Drk: This is what the ****ers at MySQL convince these people.
<0> I just wish that they would all wear special hats so that I could weed them out in the interview process easier.
<1> ACID man. ACID.
<1> If its not ACID, its not a database.
<2> i can't get the nopaste to work
<1> Halo_Four: I know that mysql is getting better, and I use it for some small "toy" projects, but I'd still neveru se it for anything big. Not robust enough yet.
<2> http://sql-servers.com/nopaste/?show=111
<2> why does not that work
<2> should it be more like SELECT field1 / 100 as BetterField, sum(field2) FROM table1 GROUP BY BetterField
<2> which doesn't work in oracle but does work in mysql btw
<2> so there
<0> That working would be a bug in MySQL
<0> Not surprised, I've heard of a lot of bugs with grouping in MySQL
<1> Well, the fact that you're using having instad of where illustrates exactly how much you know about SQL.
<0> You need to group by field1
<2> you need to use having in this query
<1> You use having on aggregate fields. You use where on non-aggregates.
<2> having is required here
<2> why doesn't oracle support PIVOT or TRANSFORM those are ansi commands and you cant use them
<3> why is the sky blue
<2> Fly_Wario: get lost if you don't want to help
<3> uhm.. no.
<4> Pujol stop asking questions, until you read your book and you start using a real dbms
<5> PIVOT isnt ansi sql
<2> what book zoul
<2> it's not?
<5> no
<5> of course its ****ing now
<5> not
<2> hmm
<2> why of course?
<5> its a report/matrix function
<5> pivot has nothing to do with relational calculus
<2> ?
<2> what's relational calculus
<5> ITS ****ING SQL
<2> is that like dy/dx
<6> "relational calculus" that's a new one.
<2> do you mean select * from TABEL type of stuff?
<5> sigh
<5> everyone **** off and die
<5> read codd
<2> i need to insert a column that does like =sum(price) where price is the third and fourth column
<2> and i need another one to be a vlookup from another table
<1> You could all also learn exactly what calculus means, too.
<2> my brother took that
<2> i tried compacting and repairing but it didn't help
<2> it's pronounced 'sequel' right?
<6> heh
<7> lol
<2> what
<7> the more interesting discussion is char like "char-broil" or "care"
<7> or is asp pronounced lke the snake "asp" or spelled out "a.s.p."
<2> well my friend (who has the A+ cert) says it's ess q ell
<7> all very fascinating discussions
<6> I go with char broil
<7> oh, well if he's a+ then he must know everything :P
<6> A+ certs are useful... when the TP isn't available.
<7> i think im the minority with "care", but I try to use "char-broil" so I dont stand out
<2> he helped me get my cd burner working
<3> that makes him a pro
<6> No, that makes him A+
<3> heh
<5> hahah
<5> a+ certified
<2> is that a joke?
<5> sad
<5> I was a+ certified in like 95 when I made 8 dollars an hour
<2> i hope to get A+ in the next year or two
<2> first i need to get MOUS
<6> pujol: I dn't know that those certs have much real-world value. Though possibly it gets your foot in the door for entry level positions. Others may know better than I though.
<2> i want to be a database administrator
<2> i can use Access to catalogue my VCR collection
<6> great. Sounds like you're well on your way. Be sure to put that on your resume.
<2> no, i meant once i get some on the job training
<4> people who pronounce SQL as 'sequel' need to be shot
<4> acronyms are just that, their not words ... their ****ing acronyms ... 'sql' is 'S Q L', 'OLE' is 'O L E' (not 'oh-lay') ... etc, etc
<2> what's LASER?
<2> what's TRON
<4> and 'char-broil' or 'care' is a personal preference ...
<2> what's XBOX
<2> what's LINUX
<4> Pujol xbox is xbox ...
<4> linux is linux
<2> what's ATM
<8> zoul : what's wron g with that? it's two syllabls instead of 3
<4> linux isn't an acroynm anyhow
<4> YuppieScm cause it sounds dumb ;)
<4> and neither ix 'x-box'
<8> no it doesn't
<4> YuppieScm it sounds dumb to me ...
<8> ah
<4> 'sequel' is an MS thing ...
<8> that's different
<4> I've never heard anyone refer to SQL as 'sequel' unless they were SQL Server people
<8> zoul : nah - was an ibm thing first
<4> YuppieScm as I said, I've never heard it refferred to that in any other case then sql server ... personally
<4> where it originated, is beyond my scope of knowledge
<4> nor do I care, I think it's dumb ;)
<8> fe... but both ibm and sybase used 'sequel' before ms did
<4> i mean, **** ... people here at my office, they call "GUID" "Goo-ids" instead of "G U I D"
<8> er, yeah?
<8> and
<8> ?
<4> YuppieScm as I said, I don't care where it originated, it sounds dumb ...
<4> giving acronym's "word" pronunciations is just weird ...
<8> not really... it has a long tradition - laser being a good example, as given earlier
<6> Seems like a natural mnemonic.
<4> you ever hear someone talk about IT stuff, referring to a ton of acronyms ... using their word pronunciations?
<4> they sound like retards
<6> if it's easily confused with other words in the sentence, then yes, that's dumb.
<4> The GUID in SQL Server needs to be replaced with an SUID, especially with OLEDB via ADODB
<4> person just sounds like an idiot when they pronounce all those out as words
<8> zoul : ah... what about OLE?
<4> O L E ... no "oh-lay"
<8> that was a word BEFORE it was an acromyn
<4> what word is "ole"
<4> spanish ? :)
<8> it's spanish
<8> (not mexican)
<4> just because the acronym IS a word, doesn't mean you pronounce it as a word ...
<4> cause then that confuses the 'word' with the 'acronym'
<8> context is all
<4> LASER is an acronym thats
<4> acceptable to be spoken out ...
<8> why?
<4> 1) the acronym is long as **** ...
<4> 2) it sounds normal when it's spoken
<8> 'sounds' normal, because you're used to it
<8> no-one was used to it 50 years ago
<8> hm... biztlak?
<4> no, laser is a real word ...
<4> 'sql' and 'sequel' are totally different ...
<6> hoo boy.
<4> 'sql' is pronounced 'sequel' cause some jack*** thought it sounded good, but 'sequel' takes 'sql' and changes it's overall meaning
<9> heh
<4> 'structured query langauge' and 'sequel' ... 'sequel' meaning 'second version of' ...
<4> wtf?
<9> sequel sounds weird to me
<4> anyhow ... personal opinion of myself ...
Return to
#sql
or
Go to some related
logs:
#computers
delphi UTF8Encode
#nhl
#beginner
curry nivida
.Wortdlist
hdderase ubuntu
compaq r3000 flashing lightning bolt charge
#politics
#nhl
|
|