| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> point-n-drag is great hehe
<1> indeed - so is f1
<0> as long as i know the term
<1> the term is FK
<1> go read
<0> thx
<0> sorry man
<0> now i know its a foreig key
<1> bricecube : still whining, i see
<2> nah.. I came back to check out your politics
<1> bricecube : still too cool to read the rules or the topic
<1> my politics?
<2> ya.. how you run this channel
<1> easy - nihilist
<1> i don't run the channel
<2> go fence your children
<1> hahahahaha
<3> omg
<3> I HATE THIS PLACE
<3> AND THIS POLITICS aND **** U
<3> then come back 2days later
<3> hi i have this problem...
<1> yah - i have this problem - i can't stab people in the face with a fork over irc
<3> hahahah
<4> hmm
<1> i need to create "paystab"
<4> yes yes we all read it on bash.org
<4> be original
<1> justinm : well done for ecollection
<1> s/e/r
<1> paystab was original tho
<1> um
<4> just
<4> just stop
<3> no
<3> u stop
<1> sure
<4> stop what?
<3> JUST STOP
<3> !!!!!!!1
<4> I ALREADY HAVE ONE
<3> nope
<3> lol
<4> cl***y
<1> because it was funny
<4> oh hiz I have this problem
<4> haha
<0> aaaaaah it works! :)
<0> i actually do learn hehe
<1> thank **** for that
<1> k, so g'night all
<3> k,8
<3> l8r
<5> for mssql2005, are you supposed to pay for a seperate CAL for each web server which will accessing the sql server?
<5> ms licensing crap hurts my head
<6> fooey|wrk : ask your ms rep
<5> aww, that's no fun
<6> fooey|wrk : boo-****ing-hoo
<3> heh
<3> it will probably be cheaper to get a processor license
<3> especialy if its being used for multiple web servers
<4> pirate
<4> then when ms busts you for piracy and sues you, register all your software and counter sue them
<0> yeah right
<7> hey all
<7> so how can i merge rows/records on NULL or newer data (***uming "newer" is defined by a timestamp in each record which can be compared) ?
<8> what could cause a page timeout in an asp.net page when trying to retrieve a 200K image data type from my sql 2005 about 50% of the time
<8> the IIS and sql servers are on different machines but same local network
<8> what happens when an auto increment field of type int reaches its limit
<3> i think more importantly is
<3> what happens when it reaches its limit
<3> and it cant come up with any more unique numbers
<3> lmao
<8> huh
<8> that was my question
<3> no actually
<3> your question has 2 scenarios
<3> cauyse like what if you delete 10 million records
<3> and it hits its max
<3> it could technically start over
<3> and the numbers would be unique
<3> :p
<8> well yea that's what I want to know is if it will wrap around
<8> but I don't think it does
<8> I think it only goes up
<8> "auto increment"
<9> It goes boom
<8> I guess if it reaches its limit just change the data type to something that can hold larger numbers
<8> a better solution is to generate a MD5 or CRC hash of the primary key values and store that in a field as the unique ID
<8> sql server should have that built in
<8> "create unique ID based on these fields"
<0> is this correct thinking: never delete a product if there is a relationship to the order-table?
<0> even if the order-table contains reductant data
<10> its your data, do whatever you want with i
<0> not the answer i had in mind hehe
<11> is anyone familiar with p***ing an array as a parameter to a stored proc via an XML string in ms sql 2005 ?
<11> :/
<12> uh
<11> ?
<7> kinda
<7> i did a bit of that in 2k... haven't tried 2k5 yet
<11> its probably basically the same thing
<11> i have no problem inserting records this way
<7> ew
<7> ok
<11> but i also need to update in the same manner, and i can't figure out a way to increment through each paramater and see if it exists before i update it
<7> well...
<7> you could use UPDATE triggers
<7> but that's beside the point
<7> you could easily do an UPDATE blah JOIN x
<7> to update all the records before you insert
<11> i was trying something like this:
<11> http://sql-servers.com/nopaste/?show=317
<11> i think i'm way off though
<11> hmm
<13> hello all, trying to get a table created in Oracle XE using sql statements. I have this table working in MSQL and postgresql but having trouble getting it to work in Oracle. I am brand spanking new to oracle but im a bit confused. The stupid error im getting is
<13> ORA-00907: missing right parenthesis
<13> but no line is reported
<13> if i paste the lines could someone please help ?
<14> read the ****ing topic thks
<13> ****
<13> sorry
<15> YEA
<13> doh
<14> use the web site and if someone can help you they will
<14> i'll take a look but no promises
<13> cheers done
<13> under Brad
<13> i wish the **** would report the line number the error is on surely even the free version would report the line number ?
<13> does any1 know how to get oracle xe to report the line error the error occured on ?
<14> roger_Ram, do you have a link to where you posted your message
<13> http://sql-servers.com/nopaste/?show=318
<13> thanks for your help
<13> i feel like a **** cant even create a stinkin table in oracle ....
<13> terminus did u get a chance to have a look ?
<14> sorry i will right now
<14> got distracted
<14> one sec i think i see it
<13> no worries .. its just pissin me off majorly if it reported what ****in line the parenthesis was missing i would know
<16> hahahaha
<16> "If it was easy, the code would be readable."
<16> old programming joke...
<14> it says error at line 3
<13> u using a decent version of oracle?
<16> try INT instead of IND...
Return to
#sql
or
Go to some related
logs:
#delphi
#politics
#worldcup
15mbit mtu size router
#netbsd
#nhl
ubuntostudio
#politics
xp_cd_key_changer.zip
#computers
|
|