| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> www.dictionary.com
<1> www.cracksmoke.com ?
<2> I think I'll go to the grocery
<2> hopefully you guys will have either kissed and made up or killed each other by then
<3> sisterly love is so fun to watch
<4> or they'll still be making up, and you can come back and walk in on them in an awkward embar***ing position
<1> eh, when we first were talking at the same time, i was poking fun of someone and Darken| thought i was being serious. he hasnt liked me since then :P
<3> well, screw you guys, i am going home!
<2> heh
<5> :) painful weekend ... ttylz
<6> can anyone here hack websites and remove content from them? I am doing this for the purpose of elimating phishing, pls contact me
<0> hanif screw off before you get banned
<7> sql server
<7> hi folks..
<7> if i have a comma delimited list as a value in a field... i.e. 1,2,3,4,5
<7> and i have a value from a form field which is also a comma delimited list from a multi select box..
<7> i need to see if any of the values from the form field are in the list in the db field value
<7> if the form field value is 1,3,4 i need to see if 1,2,3,4,5 has 1 or 3 or 4 in it
<8> < Galanga> if i have a comma delimited list as a value in a field... i.e. 1,2,3,4,5 <- Why do you hav that?
<9> what is the best way of sending thousands of UPDATE queries to a MySQL table at the same time? the data is coming from a tab delimited file.
<7> upb: heh yea i know it's not recommended practice, best to have another table but this isn't serious, i just want to know if it can be done
<8> dunno :/
<7> interesting question don't u think?
<8> you could prolly do it with a loop inside a sp
<8> split by , and test every token against the second argument (the field)
<7> i thought i could do it with cf but it ain't that easy
<8> cf?
<7> cold fusion
<8> oh
<7> does tsql have a sort of "listfind" function?
<7> i wish it did
<7> then u could go "where listfind(list_in_db, currentvalueofyourloop) > 0"
<10> where myjizz in (select jizz0r from list)
<7> heheh
<11> 1) Dont ask if you can ask a question, just ask it.
<11> oh hell no, this ain't no question channel
<0> weren't you banned?
<11> you're the op, you tell me
<0> i believe you were
<0> be nice
<11> 2) If you ask a database question, and dont say what database youre using (MSSQL, Oracle, Access etc) expect to be ignored/kicked/slaughtered.
<11> my question is, again: there's a select top 10 * from table syntax in SQL server and I need the oracle 10g equivalent
<11> yep, rule 2 is satisfied
<8> read about rownum
<8> and subqueries
<11> thats crazy you mean oracle doesn't have any sort of 'top' syntax?
<11> I'll google rownum though thanks
<12> tbh
<12> SELECT TOP 10
<12> is pretty ****ing stupid imho
<12> its like decicing to put rims on your car but not putting any tires on them
<11> spoken like a TRUE dba
<11> dood, work in industry and get back to me
<8> lol
<11> I KNOW 8i had something like it, but that was five years ago and I don't have my docs
<0> guest2 don't start har***ing people again
<11> * Added Darken|!*@* to ignore list
<12> http://search.yahoo.com/search?p=download+Oracle+10i+documentation&sp=1&fr2=sp-top&ei=UTF-8&fr=b2ie7&SpellState=n-3029975371_q-A4Rg3ANf1aSb4T8EoODa7AABAA%40%40
<12> :(
<12> http://search.yahoo.com/search?p=download+Oracle+10g+documentation&ei=UTF-8&fr=b2ie7&x=wrt
<12> ahh thats better
<11> thats cool thanks
<13> guest2: http://www.ss64.com/ora/
<13> Slightly old, but still amazingly useful as a quick ref.
<11> hell yeah
<2> guest2: rownum
<2> hmm, it seems Oracle has FIRST_ROWS(n) now... I wonder if it works
<11> whats the example select for using rownum?
<11> or what page are you looking at
<12> http://search.yahoo.com/search?p=download+Oracle+10g+documentation&ei=UTF-8&fr=b2ie7&x=wrt
<2> I don't need to look at a web page
<2> I use my brain instead
<13> rownum is just a psuedo column, starts at 0 and works up for each row.
<13> Pretty simple.
<13> Toss it in the where clause.
<11> creat man, happy for ya...whats an example select statement that uses rownum
<12> lmao
<8> ummmm
<11> I tried that and pasted the error
<8> it starts at 1 doent it?
<12> whats an example of siomebody being kicked out cause he is too ****ing stupid ?
<2> SELECT * FROM foo WHERE rownum < 10;
<12> Hi Welcome to SQL 101
<2> and yes, it starts at 1
<11> umm, that don't work
<12> Please have a seat while our instructor rmah teaches
<2> guest2: you should replace "foo" with your table name
<11> tried that
<8> lol typical
<11> yeah no **** sherlock
<8> 'doesnt work'
<8> whats the error?
<11> why don't you ***holes just say you've never don it before and don't know
<11> hehehe
<12> ....
<11> I pasted it earlier and got kicked
<11> for flooding
<12> why dont you get kicked again and read the topic
<13> upb: It may. Its been a while since I worked with oracle a lot :)
<13> guest2: rowid and rownum are two entirely different things. Maybe you should try actually doing what you're told instead of bitching?
<2> guest2: what query, *exactly*, did you try?
<11> hang on
<13> Reminds me of the time I went to radio shack and asked for a DVI to VGA adapter and got told "We don't have one of those, but I've got something kinda like it."
<12> heh
<2> why is it taking so long for guest2 to type a simple query?
<13> Hard to formualte a witty comeback when the error was do to his own stupidity and inability to follow directions.
<8> lol":[p
<2> heh
<2> Now I understand why some of my teachers in HS did those "read the entire test first" tests where the last instruction was something like "ignore the other questions"
<12> rofl
<8> i never got one of those :(
<2> HS should be run like USMC boot camp, IMO
<12> heh
<12> and school like Army boot camp
<12> ^elementary
<2> army grunts are like pansies
<4> then we'd end up with a country full of ***holes
<2> phargle: are you a commie or a terrorist or something?
<4> * more ***holes
<4> i mean.
<12> phargle - we already have a country full of ***holes
<12> lmao
<12> and idiots
<4> hehe
<12> ***holes,idiots, whiners
<2> I have the greatest of respect for jarheads
<12> lot of people are set pretty straight when they go through military camp, the harder the camp the straighter
<2> yup
<2> disipline and humility are two personality traits that are sorely lacking in today's youth culture
<2> all that idiotic "self esteme" bull****
<12> everybodys teaching self esteem in schools
<2> erm, self esteem
<12> build up the self esteeem
<12> what happens if if you build somebody self esteem. who will strip dance
<2> IMO, if you haven't done anything worthwhile, you *should* have low self-esteem
<12> bleah i cant say it right
<2> otherwise, it's just narcisism
<2> Arrakis: feeling good about yourself when you're a slack-jawed idiot lame *** is good for no one
<10> stfu
<12> http://launch.yahoo.com/ar-4463747---Lazyboy
<2> hah
<12> scsroll down to "Music Videos"
<12> and watchthat music video
<12> that is sooo much <3
<2> of "Underwear goes inside your pants"?
<12> yeah
<12> the music video
<12> its the "next" section
<2> ok, I'll risk it
<12> underneath thestupid downloads
Return to
#sql
or
Go to some related
logs:
#opengl
#computers
#windows
#linuxhelp
slim nude pic
#windowsxp
#politics
#cisco
#beginner
#gamedev
|
|