| |
| |
| |
|
Page: 1 2 3
Comments:
<0> cool you snowboard?
<0> trashboard?
<1> both
<1> tom skiing i think
<1> depends who i go with
<2> Quant, sweet
<2> where are you going?
<1> camelback
<2> err... I forgot that you probably don't live in bc, hence I will have no idea where that is ;p
<3> is it considered a horrible idea to have your application generate primary keys as a 12-digit char?
<4> Seems silly.
<4> Probably take a performance hit from the size of the key too.
<2> whoa
<2> whoa!
<2> why would you do taht?
<2> just start at 1000 and make your code insert max+1 or something
<3> nah, never max+1.. always self-incrementing sequences
<3> this persons code likes to deal with it himself
<3> i suppose i should take a look at the collision risks
<3> it might be worth changing
<2> are self incrementing sequences faster then inserting a max+1
<3> at least marginally
<3> hmm... 12-digit A-Z0-9
<2> well... I suppose marginal differences add up after a while
<4> There's also no possibility of a collision with an autoinc either.
<5> hello
<5> is mysql a real sql server
<0> no
<5> ok
<5> so i guess oracle is the most powerful
<0> no
<6> depends on what you are doing
<7> "Most powerful" is a fairly arbitrary designation.
<8> but it usually is ;)
<9> lol
<1> jarett is trolling :)
<9> is jarret never trolling ? :S
<9> OMG IM GOING TO GO THELL :'(
<10> yesterday I spent about 12 hours converting around 200 queries into stored procedures to comply with some changes in this application that our client wanted, and im going through debugging making sure everything fits back together, and I'm having the oddest error when I call one of my insert stored procedures it's adding the object twice
<10> was wondering if there may be a common problem related to this
<11> im trying to insert multiple values into a table for oracleSQL*PLUS ... insert into table values ('bla','bla'), ('bla','blak'); ... but this doesnt work?
<7> Sure Oracle supports said syntax?
<7> That syntax appears to be specific to DB2
<11> so i have to type everything
<7> You would have to issue multiple INSERT INTO statements, yes.
<11> know if INSERT ALL INTO TABLE works with sql*plus?
<11> how do you comment in SQL? is it // or #
<1> --
<12> niglets : depends on the rdbms
<12> can all work, depending
<12> niglets : // -- and /*...*/
<1> in sqlserver it's -- for single line and /* */ for more
<12> Quant : // also works, depending on version
<1> which version
<12> the blue one
<13> I have a SQL Server 2005 enviornment running and I want to install Visual Studio 2005. VS2005 requries me to uninstall all SQL Server 2005 products first. I have backed up my database. Will I be able to restore the database after uninstalling and again installing SQL Server 2005?
<9> lol
<9> that is major *** banditry
<13> Arrakis: are you responding to my comment?
<9> yeah
<13> yes it is
<9> well commenting on the
<9> uninstallation specific
<9> you should be able to restore the db
<13> i have to be sure i can recover
<9> well
<9> make sure you have 2 backup copies of the db ;)
<9> just be 100
<13> otherwise when trading starts on monday everything will blow up
<9> % sure
<9> lmao
<9> heh
<9> well
<9> if push comes to shove
<9> make 2 backups
<13> ok thanks
<9> if for some reason it fails uninstall vs 2k5 and resintall sql 2k5
<9> but i dont see any reason why it should
<14> or perhaps don't do it
<9> fail
<9> i think people are even restoring sql 2k dbs
<9> with minor problems
<14> if you can break something important by doing this, and you can't test it first, don't do it
<9> whats the fun in that :(
<9> GuntherX ur a spoil sport ya know that :(
<13> well
<13> i want to improve my development enviornment
<13> my boss is too ignorant and cheap to buy a production enviornment computer
<14> buy a poster for the wall
<13> no im going to do it
<14> so the prod box is the one on your desk
<14> ?
<13> yup
<8> peano_, why not use vmware and quit whining?
<13> my machine would die if i ran vmware
<14> why not let the janitors unplug it one night
<8> peano_, i guess your boss doesnt like you much
<8> or you are an inferior worker
<13> no hes just a cheap jew
<13> no antisemitism inteded
<13> its just true
<9> hehehe
<9> peano_ - less talk talk more work work
<13> soon i will be getting an old celeron for production
<13> no monitor though
<8> i have 20 servers all running 400mhz or less, and they are all probably processing more data than you can think about in a year
<8> and no, a production server shouldnt have a monitor
<13> thats encouraging
<8> you whine alot. maybe thats why he wont get you anything. you dont do with what you have
<8> can you prove that a new server would mean 10x more revenue as he put into buying it?
<13> we develop and deploy quantiative strategies at a rapid pace
<8> wow you should be a manager
<8> you just spouted out alot of useless buzzwords all in a row and said nothing
<9> 9ooooooh
<9> buzz words
<13> quantitative financial strategies Jarett_
<8> i think i just won the channel buzzword bingo in 1 sentence
<13> what hedge funds do
<9> oooh
<9> financial
<9> mmmmm
<13> perhaps youre confusing well defined technical terms with buzz words
<13> what i need is a database cluster and a beowulf cluster
<9> i need more "financial" experience
<8> ok i KNOW i won bingo with "beowolf" and cluster lol
<8> peano_, are you an mcse?
<13> no im not
<13> im a mathematician
<8> i dont know which is worse
<9> no
<9> ur peano_
<9> you can't fool me
<13> i used to work with sun clusters all the time when i was in school
<9> *** No such nick/channel: mathematician
<8> leave the computer talk and db work to people who know what they are doing
<8> use irc on a shell != work with
<13> im new to db
<13> and windows
<10> Using SQL Server, I want to return an Identity Value after an insert in a stored procedure. I am basically doing create proc as ....insert .... select scope_identity() ... how can I retrieve that value from my dataadapter?
<15> sethd:: DataAdaptor as in .NET cl***?
<10> yes i know probably not the appropriate channel, i fixed the problem already
<16> k
<17> I am creating a race result database
<17> and I need some advice on my table design
<1> ask carpathia
<17> is he here?
<1> i duno
<17> anyone here?
<18> TommyGavn: He left.
Return to
#sql
or
Go to some related
logs:
#computers
#beginner
#gentoo
#3dsmax
#netbsd
getbackbuffer remotely
#politics
FLEXTRIAN
chetting room
ATI Chipset All in one WHQL
|
|