| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> is this the correct format for the update
<0> update mytable where field1 = 'something' set field2='Y';
<1> no
<1> as i think you already found out
<0> i haventr tried it yet
<1> put set before where
<1> then rtfm
<2> does mssql have a ignore feature where it ignores the ip for a period of time due to a certain number of failed attempts
<1> yes
<1> and its default limit is retarded
<1> 3 or something
<2> seems like it because someoen's been trying to brute force my server for the past few days
<1> your mysql server is open to internet traffic ?
<2> yea
<3> :x
<1> why
<2> it's a test server
<1> thats no excuse ;-)
<2> it gives me a central location to use sql for testing purposes
<2> and there's no critical data so I doesn't even matter if someone obtains the info
<2> be that's besides the point. I don't want someone brute forcing my server :P
<1> then youre contradicting yourself
<1> firewall it
<2> I should remove the p***word for the sa account, downgrade permissions to view a table that has a table with a thousand rows of '**** you' in it
<2> view a db that has a table...
<1> personally id just firewall it, but whatever floats your boat :p
<4> Hey ppl :).. i'm using MSSQL and have this query that i would like to do but it's kicking me in the nadz :/..
<4> http://sql-servers.com/nopaste/?show=238 <- if anyone is interested..
<4> i get 6 rows from that query.. and i would like to just get 2.. the latest posts ones only..
<4> as it is now i get 1 row from every post in that forum..
<4> 2 forums, 3 posts in each = 6..
<1> would suggest your JOIN criteria is too lax
<1> or uh, how do you define latest
<4> that is what i would like to know :D..
<1> you want the latest post from each forum only?
<4> i also would like to know how to just get 1 row..
<4> yep
<1> so add to the where clause
<1> and postid = (select max(postid) for that forum)
<4> i've been trying but somehow i seem to mess it up..
<4> ooh.. how stupid am i.. here i've been trying and trying to do that with the datetime..
<4> thanx :D.. i'm gonna try that.. probably will work too
<1> np
<3> when you have a n:n mapping table, do you do a clustered PK on the values?
<1> that woul depend on whether it changes frequently, and how often you query it
<1> PK or sure, not sure about clustered if it ifs very volatile
<1> PK for sure
<1> or if you do, set your fill factor to 80% or something
<3> so if you have table People, and table Groups, you have an intermediate PeopleGroups table with columns ID, PeopleID, GroupID?
<3> i was thinking just PeopleID and GroupID, clustered pk
<1> then whats the purpose of the id column?
<3> i don't see any purpose at all, other than if you wanted to somehow identify the relationship of people->group with a single int
<5> evening
<6> evening
<1> but since ID isnt part of the PK, its useless
<1> and eating up disk space and I/O time
<1> get rid of ID then PK the two fields
<3> ohh i think i didn't say that well
<3> i don't put an ID in there
<3> i just have PeopleID and GroupID as clustered PK
<1> ok
<3> was just wondering if that makes the most sense for a relationship like this
<1> yes, go for it
<1> just remember about fill factor since your clustered index will require a lot of disk shufling otherwise
<3> what is the default fill factor?
<3> oh 0
<1> 0 is same as 100%
<3> ok i'll take your suggestion @ 80% thanks
<7> bitch titz
<8> **** ****
<8> chronic tourettes
<8> and chronic sign language tourettes
<7> yo
<7> it's saturday
<7> and yest was friday
<7> did you get it?
<8> yes
<8> it takes 3-4 days from what i recall to feel the full effects
<8> but i feel ****ing great so far
<8> i can't stop eating
<7> oh yea? hot
<7> congrats
<7> so you eat and nothing bad happenz?
<8> tiny bit
<8> as i said it takes a few days to run through my system completely
<8> i feel maybe..
<8> 5% of the pain
<8> if that?
<8> it'll get better over the next 2-3 days
<7> so like
<7> 5% of the best? or none at all when fully kix in?
<8> i will have almost no issues when it fully kicks in
<8> ive lost about 95% of the problems so far
<8> if that makes sense
<7> hehe
<8> it's progressively getting better
<7> and how long are they gonna be paying for it?
<8> my appetite has increased 3-4x
<8> within 24 hours
<8> dunno
<7> take your time with college
<7> you gona have to go PHD and ****
<8> i'm already gaining weight
<8> lol
<8> 2 phd's
<8> ;)
<7> so you gonna be winning double
<8> i should have it for another..
<8> 1-3 years
<7> then you gonna be able to pay for insurance yourself
<8> so for then i'll be good and be able to go to school
<8> hehe
<7> it's only 5k a year no?
<8> for what
<7> insurance
<8> for the payment
<7> yes
<8> or copays, or what
<7> no
<7> to have health insurance
<7> it's 5k a year i think
<8> it varies for each person
<8> each person's company has a different agreement with a different health insurance provider
<8> maybe $5 for one person
<8> $10,000 for another
<7> how much for you?
<8> and then you still have copayments
<8> i don't wish to discuss that
<8> it doesn't matter lol
<7> lol
<7> ok
<8> it's taken care of is all that matters
<8> i was going to cook a huge dinner for my family tonight
<8> but no one can be home
<8> so another day
<8> i've easily eaten 4000 calories today
<8> m***ive appetite
<8> still need more food
<8> i say give me 2 months quant
<8> ill gain 40lbs
<8> :)
<9> Hi!
<9> I need help with sql and fox pro, please, can someone help me, and if speak in spanish better! ;)
<5> what sort of help?
<9> I will make it short... I have an exam in the university of that, and I must learn how to make tables and that stuff in less than 7 days
<9> :)
<10> well that won't be hard
<10> good luck
<9> reall?
<5> yup, really... it's covered quite extensively in the documentation
<9> really? cm on... I've instaled mirc and everything seaching for help...
Return to
#sql
or
Go to some related
logs:
gentoo FATAL: Error inserting vmmon Invalid module format
#worldcup
#politics
#computers
#beginner
#nhl
ronaldhino jar jar binks
#politics
qla2200 leadville driver solaris 10
#beginner
|
|