| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> I want to learn before I take the certification
<1> seracht, as far as SQL language goes, general syntax is quite similar. as far as DB and system management goes, they'll be completely different
<1> as soon as you get past basic SQL though syntax will diverge
<0> alright mmunky thank you for your help
<0> I will start using the SQL Server Express edition
<0> are there any tutorials that you can recommend?
<2> I disagree
<3> www.google.com
<2> no
<2> yar
<4> yow
<2> wowzers!
<5> in sql server 2005, how can i update a column by dividing all of its values by 2?
<5> without a stored procedure
<6> the whole table?
<5> just one column
<6> aargh
<6> Your knowledge is dangerous. I'm asking you if you want to update the entire table or just one row?
<5> oh. sorry. i actually want to update only parts of the table
<5> WHERE Date <= '2005-09-21'
<6> you want decimals or whole numbers?
<5> money
<6> update [tablename] set [columnname] = [columnname] / 2.0 where [datecolumnname] < '2005-09-21'
<5> er
<5> float
<6> i am encouraged to se the ISO 8601 date, at least
<5> ah oh
<5> thanks
<6> yw
<5> i thought it would be something simple
<6> it often is with sQL
<2> ISO-8601 is the one true date/time format
<2> everyone should use it all the time
<6> indeed.
<6> I get the biggest kick out of crap like '05/04/06'
<5> its not as bad as using integers
<2> **** man, have you guys seen the new Beretta 90two handgun.... talk about SWEEET
<5> thats not as bad i mean
<6> haven't seen it
<2> http://www.beretta.com/index.aspx?m=74&idc=2&ids=60
<6> cool
<2> I wonder how it stacks up to the Sig 229 or Sig 2022
<2> I generally prefer sigs
<2> well, sleep time
<2> g'night
<6> night
<7> MSSQL 2000: Using Merge Replication, I'm keeping 2 databases synced, but it appears that when I do a batch of inserts (typically 12,000 - 30,000 at a time) I can see that only 100 inserts occur at a time (looking at the merge agent info in the replication manager). I'm also seeing that I'm averaging 65 rows/sec. Can either of these be controlled/managed?
<8> Where can i learn how to work with SQL Enterprise server ?
<9> liran: from the internet
<9> or some books
<10> is it common for enterprise managers to be denied connection, if i am running it from my computer -> web server?
<11> Anyone here having a BITME.ORG account :-D ?
<12> can I get the month from a date in a select statement. using access
<13> new security web site http://recognize-security.cjb.co.il
<10> yay for israel
<14> israel ****s
<10> yeah i must say, they do give good head.
<14> you must be talking about the non jewish israelis, cause everyone knows that jewish girls don't give [good] head
<10> hehehehe
<14> christ, i can't ****ing stand it when people name db columns with 'fk' in it to show its a foreign key
<14> questionIDFK
<15> yuppie
<10> i cant connect to whsql-v09.prod.mesa1.secureserver.net
<10>
<10> from home ;(
<16> wtf is that gay ****?
<16> no mysql?
<16> hahahahahahahahahaha
<17> #mysql exists, bother them
<16> how about not bothering ME with gay notice **** on join
<17> heh, loser
<18> no doubt
<19> I have the following in one of my oracle Stored Procedure " execute immediate 'exec sp_spin_id_update2(' || Varunique_id ||')';" But for some reason it bombs out when the SP gets to that line... Is it dying because of the variable I am p***ing in?
<19> anyone around?
<18> I need an alter table query.. changing the table name
<18> how is that done again
<18> ?
<18> field name*
<18> I meant field name
<18> :P
<20> knowone: u know they have these things.. like books and stuff
<20> and places online where u can look it up
<21> I got a problem... I cant get the ORs to work in the end of my file...... its VERY anoying :) anyone know why? http://sql-servers.com/nopaste/?show=656
<18> SicLuDe: lol :P alter table bla bla, thought I was gonna get a quick answer from you guru's ;p
<22> I need to remove similars records from my database, my query fails, i've paste it there : http://pastebin.com/711527
<23> "ANY"?
<23> eww
<23> #1 mysql is supported in #mysql
<22> they only know configure things not SQL
<23> go figure
<22> is it from SQL point of wview correct
<22> ?
<22> i've did it
<22> they don't know
<22> don't cheat stupid things like that i'm bored with guys like you bye bye
<23> that 'any' will bite him one day
<17> The level of self-entitlement is amazing.
<24> need some select statment magic. I'm still fairly new to SQL. I have 10 values in a row (pid1 - pid9) and 10 flags (flag1-flag9)
<24> Given a pid I need to retrive the flag for it, the pid can be in any of the colums 1-9, any select magic I can work or do I have to check each pid value in a different statment?
<25> hey all, anyone work on monitoring databases? ie, logins logouts, attempts, and alerts?
<24> just need to know if it's possible so I can go look for the answer
<20> hmm dont know how magic
<23> mnemonic what db?
<25> ms sql
<25> 05
<23> LilCasper thats nasty.
<23> mnemonic nagios on a linux box ;)
<24> yes, it is
<23> and triggers for auditing log in and outs in the db
<25> i want to basicly monitor for login attempts for security,
<25> nagios?
<24> i'm storing poker hand records, pid is a unique player ID, problem is they can be sitting in any one of 10 seats per hand
<23> LilCasper you are basically going to transpose the output
<23> dude thats a horrible design
<25> rj: where would i start. i mucked around a bit in the profiler, and the performance monitor
<24> it's either that or have 10 enteries per hand
<23> vs a gameID, handID, playerID
<23> yeah and?
<23> youll get much better performance out of a different setup
<23> what happens when you need more players per game?
<20> LilCasper: yes its possible... look at where clause
<20> bye
<23> or your "flags" arent suitable
<23> like if you include roshambo or blind mans bluff ;)
<24> so you would recommend redesign the databse structure so instead of one entery per hand it's 10?
<24> flags are a byte long holding info on when they bet, folded, checked, and called
<23> yep
<20> LilCasper: waht you need is a flat text file... rdbms arent made to do what you are doing
<23> try indexing your design without a db which can do bitmapped indexes
<23> and add a few million rows
<23> and see how it handles it ;)
<24> ok then, I guess it's back to the design board, thank you
<23> you can do it your way
<23> i just think itll be a nightmare
<23> and youll need alot more intelligent code to handle your lookups
<24> oh i'm compleatly open to suggestions like this, if I wasn't, I wouldn't be here
<20> eh if u werent ud still be here
<24> just not sure what to make my unique index for a table like that, sence hand ID would be present 10 times
<23> mnemonic http://www.mcse.ms/archive97-2005-7-1742748.html
<23> no but the gameid, handid, and playerid would almost always be unique
<23> unless you replayed hands. which happens but you should still store the original
<24> very true...
<24> DING, lightbulb goes on. Thanks :)
<23> and betting order or other stuff would mess up your design
<23> how are you logging dealer cards, community cards?
<23> what about 7 card stud how do your 10 fields fit there?
<23> betting should be its own set of tables and logic. since oyu have multiple round sof betting per hand
<24> not logging cards yet, simply player ID and action, though cards saved per hand was the next step
<23> how are you logging action without the cards?
<24> just what they did pre-flop, flop, turn and river actualy (texas hold'em)
Return to
#sql
or
Go to some related
logs:
code for BLL file for accessing DAL file in ASP with Vbscript
xxxisraelpass illegal channel name
#gentoo
store up to 2-3 years pickled garlic
#beginner
#politics
netsnmp_assert index == tmp failed
#windows
#ubuntu
#firebird
|
|