| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> mssql 2k5.. Is there a way to attach a LOCAL file to an email in dbmail
<0> nm
<1> Local to the client? No.
<2> to the server i think
<3> roflmao
<3> http://www.compfused.com/directlink/1237/
<4> gay
<3> oh no you dzidzn
<5> how do i empty my table using sql?
<6> what rdbms?
<5> mssql2k5
<5> delete from table (no where statement) ?
<6> look up 'TRUNCATE'
<5> thank you.
<5> ah wonderbar, that is indeed what i needed
<6> much faster than delete from
<5> yes, thankyou
<7> i cant find how to get universal time from mssql
<7> get_utc() doesnt seem to work
<7> neither does getutc()
<8> catzai : try "getdocumentation()"
<4> always try random commands first
<7> aww man
<3> pwn3d
<7> select getutcdate()
<7> ha
<9> for some reason, "getutcdate()", looked like "geteducated()"
<7> well they say it doesnt matter how leters are arranged as long as the first and last letters are in the right place the human mind can read the words still
<3> looks like getUTCdate to me :)
<9> gosh.. it looks like i need "geteducated()"...
<10> http://s2.bitefight.pl/c.php?uid=38393
<8> damn
<11> still up YuppieScm ?
<8> not for the want of trying
<11> lol
<11> well, my excuse is I have work off tomorrow - whats yours?
<8> insomnia
<11> fair enough
<11> well beveryly hills cop is on itv2
<11> fair enough - nn!
<12> indeed
<12> have all 3 on dvd - all 4 lethal weapon too
<12> cba to watch ****ty edits on tv
<4> ****ty edits are my life ambition
<13> yo
<14> hi, need help qith a query: http://www.rafb.net/paste/results/Kt068U13.html i need to get all records that don't have areacodes (please check link) Can someone help?
<14> using oracle
<15> q: how do i write (t-SQL for MSSQL2k) a "select (1 if [field] IS NULL ELSE 2 if [field2] IS NULL)" or something?
<15> was thinking like a CASE, but i'm not sure what to select
<15> w/o doing PITA subselects or somethin
<15> er... sub-cases
<1> Why would it involved subcases?
<15> case field1 is null : case field2 is null: ?
<1> A case can have multiple WHEN clauses
<15> actually it's testing not null... but whatever
<1> SELECT CASE WHEN Field1 IS NOT NULL THEN 1 WHEN Field2 IS NOT NULL THEN 2 ELSE 3 END AS Result FROM Table1
<15> ah... perfect
<15> was just googling for that (syntax)
<15> thx a ton
<16> anyone in here work with ADP files ? im trying to run stored procedures through ms access front end using ms sql 2000... the procedure runs fine except the message window asks for the variable name and i would prefer to put a message
<17> oad average: 7.76, 9.40, 6.90
<17> haha
<17> load average: 7.76, 9.40, 6.90
<18> no homework damn!
<18> this trigger is killin me
<9> hmm someone messaged an op?
<1> oh, I thought that read, "m***aged an op"
<9> well... if that's what's on your head... :)
<9> i will gladly give you a m***age, which i am pretty good at
<17> 20:50:40 up 2 days, 3:59, 7 users, load average: 9.80, 7.52, 6.76
<17> snarf said "no homework damn!" when he joined, then msg'd me when I +o'd myself and asked if I could help him ...
<19> What are you doing to that machine moz?
<20> Hello im not sure really where to start but i want to do the following : i have two tables i want to find only the duplicates between the two tables. Im not interested in deleting the duplicates or in the uniques. I would like a new table produced which has the duplicates in it. I have been using google for a while. Looks like a union will work. Can you please let me know if union is the way to go ? i will keep googling rest.. thankyou
<20> briefly: i want to create table c which has records that exist in both table a and table b.. thanks again
<20> hmm i think its the intersect command, any thoughts ?
<21> I'm using sql 2k5. I'm doing a backup using a maintence plan, but it's not truncating my old transaction log. I try going to manually backup my database, and the options for log truncation aren't avaiable. Suggestions on what I'm doing wrong?
<21> Okay, it's because I was on full logging mode. I switched to simple.... though I don't understand why it doesn't truncate the log when I do a full backup, when in full logging mode?
<21> Actually... it just mostly clicked.
<21> I have to backup the log files (Or tell it to truncate) so that I can go to someplace between sucessful backup points.
<22> problart a stupid f* question .. but .. http://sql-servers.com/nopaste/?show=362
<22> thing is, i've seen references from subselects like that before .. why the hell it wont pick up on "chain c1" from the subselect is beyond me :(
<23> yech.. adding users and such is boooooooooring
<24> hi
<24> any sql ninjas in? how can i query a field of a SQL row and only return one of each result? eg if the values in the table were 1,1,2,2,3,3,3,3,4 i'd get 1,2,3,4 .. db is mysql
<24> distinct
<25> How to the instance name of my sql server?
<26> in sql server, is there a function to extract just the date portion of a DateTime column?
<19> convert.
<26> to?
<26> it seems I can convert to int to get the number of days past the base date
<26> that should work great for what I need
<26> hmm, or does it
<19> Look at the format codes in the help for convert.
<26> thanks
<27> What is the correct way for BINARY value? using:`fieldName`='MyBinary'; or... using: `fieldName`=0xFEDCBA; format?
<28> Hi. Mssql. How can i get a float, i.e 1.2340023 to be 1.23? I other words two decimal places.
<27> RadioKtrs, round() perhaps?
<28> Does that work with float?
<27> dunno, try perhaps...
<28> I get a lot of trailin 0's
<27> also check the ability of CAST() and CONVERT()
<27> better check the ROUND() Documentation first before you use that function on your Bol
<27> ... Books Online
<29> hi, how can i get substring of a string, without knowing substring length. only i know is that it should end with '/'
<27> LENGTH() ?
<23> charindex() foo'
<23> when i come across similar issues, i find it much more satisfying to browse the functions in the dbms documentation.. since you must be intuitive enough to know that substring is a function, and that there's possibly another string function for what you're looking for
<23> unless, of course, you aren't.
<30> he left
<23> aww man.
<23> i was in full sarcasm mode
<23> that ruins it.. damnit
<19> Actually, since the functions are organized by type ... browsing the string functions usually does turn up what you're looking for, unless you're a total newb dev. :)
<23> it's funny.. i wonder who he had to ask to figure out the substring function..
<28> Hmm, still cant get quite hold of only displayin two decimal places on a float.
<19> Have you tried reading the help yet?
<1> Convert it to something else.
<28> Drk`Angel, yes, im looking at the round function in bol, but doesnt return what i want :(
<1> Like NUMERIC(x, 2)
<1> And never use a floating point value for currency storage or calculations.
<28> Not currency
<23> yuck. i use float for exchange rates.. not by choice mind you.
<3> got meh?
<1> moloko plus?
<3> halo
<3> i would up enumerating System.Diagnostix.Process.GetProcesses()
<3> GlobalAddAtom() is ****
<1> Why wouldn't you just use a Mutex?
<3> seems like it's ****
<3> problems when you login Terminal Service
<1> I imagine you'll have the same problem with GetProcesses
<3> registry would be last resort
<3> i wasn't able to test GetProcesses() yet because i am not there
<1> I believe that Mutexes are session specific by default.
<1> Prefix the name with "Local\" and it will exist only in the current session.
<3> i dont want it session specific though that's the problem
<1> Then what do you want it to be?
<31> Quant whats the problems with the terminal services?
<3> Halo: i want only one instance of app on the PC period.....
<1> Quant: Global mutex, then
<1> Prefix the name with "Global\" and it will be system wide.
<32> how do I get the item_id with the most times occurring in the table?
<32> http://pastebin.com/578507
<32> i use mysql
<32> oh nvm
<32> ddnt see rule no 5
<23> there is an exception to rule no 5, if you agree to jump out of a speeding car on a freeway. jumping off tall bridges i think qualifies too
<19> You ask in #mysql
<19> Although investigating the count aggregate function might help.
<17> hrm ...
<17> getting .net 1.1 and 2.0 on the same machine is a bitch ...
Return to
#sql
or
Go to some related
logs:
hogoshti gallery
#c
#gamedev
anonib+tiny
guakamoley
#beginner
#stocks
#microsoft
#hardware
sex chinabox
|
|