| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> you know, it isn't beastiality when it's your pet because you know them
<1> Guest1: huh?
<0> just a long delayed comment about the flooder
<2> Why can't people pick nicks?
<3> hi all
<3> I have a problem
<3> the mdf file has a CRC error
<3> there is a way to recover it?
<4> phargle, me?
<4> BlackArro, no
<4> u commit suicide
<4> :/
<4> unless of course u have proper backup procedures
<2> backup file time
<4> lol
<3> my backup was of one week ago
<2> sad, my son, very sad
<4> oh no
<3> but I found a software sql server recovery
<3> it seems working
<4> *hands BlackArro the shiny teaspoon from his mug*
<3> Do you know some recovery software?
<2> allow me to ask; did you at least copy the file before you ran this *tool* ?
<3> yes
<4> im sure he did TheGamble
<4> see
<4> have some faith now
<2> I've seen too much IRC; my faith circuits are burned out
<4> :/
<3> no one can help me?
<4> did i tell u guys. i got a razor copperhead
<4> im so excited
<4> go away blackarro, im excited about my toy. j/k :P
<4> dunno really dude
<4> backup ftw
<2> indeed
<2> is this for production system?
<5> Anyone know how to tell in MSSQL what tables/indexes are being used the most?
<6> voidzilah: yes you
<7> doesnt mssql track io requests per object? oracle does :P
<5> It probably does, I just don't know where to find it
<6> your could do it with profiler
<5> I was hoping for something more aggregate,
<5> Trying to pinpoint hot indexes.
<6> output profiler to tables and rooll it up?
<6> maybe there's a .trc template or something on teh net already with all the events and **** defined
<5> ****s, SQL2005 has it right there on the front summary screen
<5> SQL2000 has to bury it somewhere
<8> do you recommend using unique identifiers in sql server? they are very messy looking
<9> depends what for
<2> slow slow day
<10> Let's say I have a column, and the column contains strings and I want to output what is the most recurring string in that column, what would be an easy way to do that?
<9> select top 1 mycol from tbl group by mycol order by count(*) desc
<11> im using MS sql server 2005 and I have a query that runs long. How can i set the query to be able to take inifite amount of time?
<12> make the query faster
<12> as far as i know... by default sql server does not have a timeout
<12> ive had queries taht ran over an hour
<12> well atleast 2000 didnt
<12> dont know if 2005 changed it
<13> How do I delete a table using psql? (Simply typing at a prompt)
<14> if you use a HAVING clause how can you add a WHERE clause ?
<7> Rpz, rpm -e postgres-server
<13> Jarett_: I'm just a user of the database, I don't wish to install RPMs
<7> thats how to delete your tables :P
<13> I don't think it would work because im not root.
<13> and also because I don't think Solaris uses RPM
<13> do you? :)
<7> http://www.google.com/search?q=postgres+drop+table&btnG=Search&hs=FQi&hl=en&lr=&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial
<13> ty, I've done it
<15> need help with a ms sql query: i need to merge rows where the first 2 columns repeat: suming the 3rd column
<15> i pasted example of what i mean
<16> alright... so i have two (mysql) tables, a players table and a weapons table. how would i write a query in php that pulls a strength stat from the weapons table and adds that value to the player's strength stat
<16> what i can do now is have one query that gets all the information from the waepon the player is equipping, and ***ign the values to variables
<16> and then use those variables in a second query for updating
<16> but that doesn't seem right
<16> i know it would work, but is there an easier (quicker) way of going about it?
<17> is this for a wow mod?
<16> no, just a simple browser game
<17> oh :/
<16> never played wow =/
<18> I_like_pi : what do you mean by 'updating'?
<16> updating the value of the str field in a specific player row
<18> so you're updating a field in one table based on a looked-up value from another?
<16> right
<16> adding the two together
<16> and replacing the first with the sum
<18> which rdbms is this for?
<16> mysql
<16> i'm looking at left join right now, it seems to make sense but the syntax is confusing me
<16> i'm hoping cause i'm tired and not cause i'm stupid haha
<18> well, you're stupid enough not to have read the channel rules in the on-join
<9> yea thats stupid
<16> ah ****, that's just a misread actually
<16> i thought #2 included mysql
<16> not m*s*sql
<16> in that case, nm
<16> out of curiosity, why the no mysql rule?
<18> because we don't allow mysql, and that seemed the most appropriate way to let people know.
<18> time for work...
<16> that's not exactly a meaningful answer
<16> but see ya later
<19> it's the exactly right answer to the question you asked
<16> you have a no mysql rule because you don't allow mysql
<19> you probably meant to ask a different question
<16> the two mean pretty much the same thing
<16> eh, maybe
<19> you asked why the rule
<19> not why no mysql allowed in the chanel
<19> bye
<16> i didn't feel it necessary to specify
<19> hey quant
<16> apparently i was mistaken
<16> ****, you guys are pretty up tight. i get the feeling you point out spelling errors in forums and that type of thing
<16> see you guys later
<20> whats more efficient using nested queries or non-nested queries? for examples select attribute1 from table1 where attribute2 IN (select attribute2 from table2 where attribute3=666) or select t1.attribute1 from table1 t1, table2 t2 where t1.attribute2=t2.attribute and t2.attribute=666?
<20> the last part should be t1.attribute2=t2.attribute2 and t2.attribute3=666
<21> hi all, how can i check in a SQL statement if a SELECT returns any row ?
<22> donnib: you talking about select statement in database package?
<21> yes
<21> i just want to make an stored procedure with some check if a row exists
<21> if i a have a SELECT * FROM WHERE blabla='asd' and i just want to know if it found any rows
<22> in oracle you should get that with if SQL%NOTFOUND then ... end if
<21> sorry i am in MSSQL2005
<22> but normally you do select ... into ... from .. when you use packages
<22> in that case you can just check if variables in into-clause have a value
<21> here is what i try to do : http://sql-servers.com/nopaste/?show=484
<21> if i find the row triing to be inserted i return the id and if i don't find it i try to create it and return the ID but i can't get it to work. i get 0 even if the row exists.
<22> sorry, i'm not too familiar with mssql
<21> it's ok. i'll see what i can do
<22> but one thing sticks in my eye, can you return a value from procedure in mssql? In oracle at least you have to use a function if you want it to return a value.
<22> otherwise in procedure you define out-parameter which brings the value to calling procedure/function
<21> you might be correct.....
<21> i don't know actually. it might be that reason why it doesn't work
<22> could be
<23> SELECT * FROM (SELECT TOP 1 * FROM (SELECT TOP 3 * FROM piReport ORDER BY pi_datePi DESC) DERIVEDTBL ORDER BY pi_datePi ASC) DERIVEDTBL2 ORDER BY pi_datePi DESC
<23> How can this MS Access query pick out two entries?
<23> they have same pi_datePi.. but why does it pick out two entries?
<24> what is my.cnf on sql50 ?
<23> ?
<25> Anyone alive?
<25> $sql = "SELECT DATE_FORMAT(date,'%M %D') as date ...... ORDER by date;" This is ordering by the date in alphabetical order as opposed to month order. Any ideas?
<26> Hi.. is there a way to display user information (username, first name, lastname, role, privileges) in a table? - that is, username created with CREATE USER command, not an INSERT INTO..
<27> why dont people read the manual?
<27> look up the sysusers table and see the related topics
<23> I got problem with an query, it's a ms access db. problem written at: http://forums.devarticles.com/general-sql-development-47/getting-too-many-entries-ms-access-50668.html
<23> someone have any ideas on how I can fix it?
<26> ok thanks
<26> thats the problem with me, i would look it up- but i wouldn't have guessed to search for 'sysusers table'
<26> so you've been very helpful
<26> now im off to read it. :)
<28> in mysql 5.0
Return to
#sql
or
Go to some related
logs:
#photoshop
#computers
#politics
#politics
mwaweel
#online
ccnp doesnt mean shit
#unix
fullsp2
girliya
|
|