| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> the fords and the toyotas of the world
<0> compared to the lexuses and the feraris of the wrold
<0> :p
<1> that isn't horrible
<0> i like rentacoder because if you need something cheap
<0> or are willing to do something cheap you can go there and pretty much at NO obligation can find something
<2> rentacoder -- Write full CRM package, willing to spend $50, need it by Thursday.
<0> elance costs money to post and to bied on job
<0> hahah yeah Halo_Four
<0> its nice for small projects
<0> like throw me together a mockup for a bleah bleah website
<0> i need a macro that does ...
<1> what kinda rates could I expect out of rentacoder, probably not much
<0> pfn - you're basicallycompeting with indian coders
<0> heh
<2> No, Indian coders make more than that.
<0> i've pulled 2-5k projects from it oc***ionally
<1> **** that
<0> yeah like i said
<3> thanks
<2> You're up again Pakastanis and Romanians on rentacoder.
<0> its like comparing toyota to a ferari or mariati
<0> or whatever that sutpid car ist hat somebodyposted
<4> how do i insert values to a table with primary key ?
<0> the 1/2 a mil on
<0> pgoery - try restating that question ?
<0> because you insert values into a table just like normal heh
<1> the same as you insert into any table with or without a primary key
<4> Arrakis: hm... well, it gives me an error due to the fact i got nothing to put on the primary key field...
<0> like www.sologig.com
<4> Arrakis: so i tried to select those columns except to the primary one?
<0> ahh pgoery
<0> perhaps you are confusing Primary key with identity
<0> primary key means its a "primary key" and its unique
<0> it does not imply a default value
<0> you probably want something like a) an identity on it if its numerical like int/bigint
<0> or put a default value of newid() if its a unique identifier - depending upon your dbms
<1> oh, identity means sequence or something in mssql?
<1> oh, and in db2, as well, heh
<2> sort of, but they're not really first cl*** entities unto themselves.
<1> just another 5 million rows to go...
<1> heh
<5> think of a primary key as a clustered index, most identity columns are likely candidates of course, but I've seen some tables with 4 or 5 primary keys that ***ociate with many other tables in various combinations
<5> and you don't necessarily want to create clustered indexes on all tables (so it might have an identity column with no formal 'primary key')
<5> tables you insert on all the time, for instance...the clustered index will slow down the insert
<6> any of you know if there exists a single-character wildcard? not % (since that matches any # of characters) but just 1?
<5> but a table that is queried or updated (using a where clause) you will want at leat a formal primary key and perhaps some other non-clustered indexes as well to speed up the queries and inserts
<5> cincero in SQL2000 it's underscore '_'
<6> ahh
<7> does running regex on an indexed column prove to be of any benefit?
<6> i fear to ask what it is for another distro ;p
<5> gawd regex on anything is slow as mol***es
<6> nah regex is teh win
<6> :)
<6> nvm, it works in MySQL too
<6> :)
<6> thanks Guest
<5> righteous!
<6> you can say at my house whenever you want to
<1> doing regex searches is rather silly
<7> well... basically i have a column full of rows, rows are a series of letters, metaphone returns to be exact...
<7> i need a way to pick out "good data" from a large table.. so i can compare the metaphones
<8> how do you define good data?
<7> looking for patterns in what feel is good data
<5> yeah, that does sound like a job for regex
<5> or one helluva where statement
<7> basically, it looks like... exact matches (obviosuly), partial matches (beginning or endings), and matches where maybe a letter or two is missing or different
Return to
#sql
or
Go to some related
logs:
xusenet pass
#solaris
toranado quotes
#sex
SNL Star wars outtakes Kevin Spacey
hemogeny
#nhl
#stocks
what is PCW
german team scores 13 goals
|
|