| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> he sold his Ferrari 355 for it
<1> i've never liked mercs
<0> well la de da mr snooty pants
<2> can u buy an atom
<2> in the usa?
<3> you can buy anything you want in the usa
<0> that's what's great about america!
<4> my dad used to sell cars, so shile i was growing up we had all kinds of *nice* cars...
<4> ****ing bouncey isp
<1> for a while i used to go to school in a pontiac firebird...
<1> quite unusual in the uk...
<3> what year
<1> damn shame it was before i could drive it legally
<0> haha
<2> nice
<1> would have been about 27 years ago
<3> ah
<1> can't remember how old the car was then
<2> yuppiescm u still in the uk?
<1> yah
<2> nice
<1> currently in uk
<2> top gear is a great show
<1> indeed
<1> i like it because they say bad things about bad cars
<1> it's obviously not just another detroit mouthpiece
<0> the driving wheels are on theh wrong side on this show
<1> rmah : use vlc to play them, it'll flip vertically
<0> haha
<1> because i just ***umed that ou meant 'steering wheels'
<0> yes
<2> yah they totally dogged the corvette
<2> leaf spring suspension
<0> you know, jeremy's mercedes SL55AMG *almost* matched a Lambo Murciolago on the track when driven by the anonymous racer
<0> the SL65AMG would probably beat it
<5> Why can't you have 2 foreign keys make up a table? (MySQL)
<0> you can in any reasonably normal SQL DB
<0> of course the fact that MySQL doesn't have real foreign keys may have something to do with this
<5> Should I just make them normal columns and link them through code rather than specifying that they're foreign keys?
<0> I have no idea
<0> we don't deal with MySQL's problems, limitations and half-***edness here
<6> heh
<7> i'm looking for a good OS parser/stemmer, anyone have a favorite?
<8> any mssql experts awake?
<9> hi
<10> I get this error when I try to connect and execute a select query on my MSSQL database: SELECT permission denied on object 'tblTest', database 'db_test', owner 'dbo'.
<11> whats your query look like
<10> "select * from tblTest"
<11> where are you executing the query from
<11> the simple answer is the account you're logged in with doesn't have select permissions on that object
<10> k
<12> i could use a hand. how come i'm allowed to erase sql entries that i created fromin a script but cant delete others that i eneterd through phpMyAdmin
<11> define 'sql entries'
<11> you created objects of some type?
<11> if so, then they were created under the account and permissions by which phpmyadmin uses to access the db
<12> sql i added via my php script
<11> login as the user that phpmyadmin uses then
<12> and i think the user is the same might be mistaken and that be the problem...
<11> thats the problem
<12> yeah i suspected
<12> but now forgot root p*** lol
<12> just testing anyways i can reinstall or find the p***
<13> Good day, can i limit the result from a JOIN to only the first row?
<13> mssql
<13> I have a table lets say (id, foo) and another where (id2, bar) where table 1 have (1,foo1; 2, foo2, ... ) and table 2 (1,bar1; 1,bar2, ...) and i only want the first row from table 2 when joining the table 2 with table 1
<11> sounds like you can just do it in the where clause, but i can't say that i understand the purpose
<13> Yea, that where my second option. Just though i was sooo ugly :)
<14> using mySQL, what does "Limit 1" mean?
<11> return only the first row that would exist in the resultset
<11> a fact which could have been answered by looking at their extensive documentation online
<15> using sql server 2000, is there a way to retrieve left of a particular character point for ex: 18485.10 i would like it to return left of anything before the "." . This number left to the period wil be dynamic and will also change in length aswell
<16> CHARINDEX and SUBSTRING
<15> coo Halo ,that pretty much an equivalent to a split huh
<17> We are thinking about a MSSQL 2005 setup with two servers and database mirroring as backend database for a websolution. Anyone know what kind of licensing that would require, do you need two processor licenses? I did not find anything clear information about that usage
<18> how would a multilanguage table look like ?
<11> like any other table?
<18> you dont say
<11> your question is too generic to answer properly
<18> currently i have columns id name and content
<19> bleh
<3> zoul
<3> ignore the last msg im not in cl***
<3> but it should be up now, sorry heh
<3> my monitor went out on me this morning i had to find another
<3> so i could login :/
<19> heh
<19> thanks ...
<19> I bought a laptop on friday, should arrive sometime this week
<19> I'll most likely start raping the plaza's free wifi ... so I won't be txt'ing you every monday ;)
<19> that is of course, if I can get away with having the laptop running ... heh, it's against company policy to have personal electronics ...
<19> their afraid I'm gonna steal their daa or some **** ...
<19> s/daa/data
<16> Not an uncommon requirement.
<16> At my last job we had a floor supervisor try to bring in an old PC from his house so he could surf the Internet.
<19> :)
<19> well, everyone here just brings in their own laptops ...
<19> but i'm on the lan admin's radar ... heh
<20> cuz moz is a hax0r
<19> he's constantly sending me emails ... telling me to stop doing things that I do ...
<19> yet no one else get's yelled at ... ;)
<20> what did you do?
<19> he scans my IE history logs, and blocks sites ...
<20> damn
<19> Quant: I do things 'the right way' ... and usually insist upon it...
<19> which makes him have to work ...
<20> what kind of sites
<19> all my CGI:IRC sites that were open efnet relays ... are blocked ...
<19> I use a proxy ... but before that, I was using CGI:IRC relays ...
<19> then when I got the proxy setup ... I was using mirc ...
<19> he caught me using mirc ... told me to uninstall that, and GAIM ...
<19> then started blocking CGI:IRC sites ... when I'd find a new one, he'd block it ...
<19> so now i'm just using putty, shelling into a shell account I run my bots and bnc on ... and using that
<19> so far, he hasn't snagged the proxy ... or blocked it ;)
<20> what part of you are not allowed to irc dont you understand? :)
<19> heh, one of the reasons I'm so proficient at my job ... is because I use IRC ;)
<19> rather then spending 8 hours looking for something ... I ask a simple 'point me in the right direction' question ...
<20> can you say spooon fed?
<19> haha ...
<19> everyone here does the same thing ...
<19> and when it comes to SQL, I don't have to ask questions ...
<19> my questions relate to things like .NET ...
<20> i more or less stopped with asking to get spoon fed lately
<20> learned to search google i guess, lol
<19> I'm not a .NET coder, and I even told them that ... but their making me one ,...
<19> I use gogle alot ... I ask when google isn't as responsive as I need it to be ...
<20> hehe
<19> besides, google doesn't always have a definitive "yes or no" answer to "can this be done" questions
<21> Heh, I love when my boss asks me what I'm working on. I show him: www.meshsoft.net/Outbox/SQL2.JPG
<21> Hes like, "Uhm, ok..." and walks away...
<19> MeshMan: you show him the screenshot ... or the actual screen on your system ... haha
<21> i just keep showing the same screenie hah
<19> I should setup a bunch of dummy screenshots ... just to alt-tab to "at the right momemnt"
<21> j/k :P
<19> hrm ... importing all this data is taking FOREVER!
<19> 1+ million records ... over a T1 ... imported into a local instance of SQL Server ... on a ****ty system ...
<22> I have a SQL server installation file, "database_name.sql", which ahs all the "create table" commands and good stuff like that. I am pretty unfamiliar with SQL Server, and i can't seem to figure out where i am supposed to load, or cut/paste this in. Can someone give me a pointer. I tried googling for the past 15 minutes, but haven't made any progress
<19> bleg55: run theprogram called "Query Analyzer" ... tell it to open the .sql file ... then point it aty the db instance you want it too ... and click the 'Run' button (or press F5)
<19> whoever gave you the .sql file should also be able to answer these questions ... if it's for a software suite you purchased, read their docs ... it might involve more then just running the .sql file ...
<19> if it's a friend, use your mouth and talk ;)
<19> hrm, you know the systems overloaded when a 'select count()' takes 10 seconds to execute ...
<23> a count(X) is a sequential scan
<23> if you're doing that on a view, it can be joining many many rows
<19> pfn: it was a flat table scan
<19> select count(*) from tblname;
<19> it returned ~2,000,000 as a result
<19> for the past year of data ... the system contains data from 5 years ago to present ...
<16> While you were importing data into that table?
<19> Halo_Four: I queried the production system ... of which I'm exporting the data ...
<16> ahh
Return to
#sql
or
Go to some related
logs:
#beginner
#gamedev
#ubuntu
#nhl
#computers
automatic proxy leecher
#beginner
50 bmg barrett joules
10.0.0.100\c$
#c
|
|