| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> sql2k, how can i see whose currently using a db ... says I can't drop it cause it's in use, but i don't know whose using it ... I wanna know who to yell at
<1> EXEC sp_who
<2> Jarett__
<2> don't you miss me in #oracle
<3> like i would miss a hemorroid
<2> :(((
<2> I thought we were buds
<3> you are sounding like quant ;)
<2> hahaha
<2> noo!
<2> well
<2> at least you'll remember
<2> did you look at the link
<3> yeah
<2> :>
<4> :/
<4> after looking into distributed transactions, linked servers, a few small set parameters (xact_abort on & remote_proc_transactions off/on), and all the other fun stuff that msdn listed on their article as to why i'm getting error 7391 in sql server 2000
<4> i still have a stored procedure that only works in query analyzer, execution be damned.
<4> on the (only) bright side i know how to use the sql server debugger and trace now :)
<5> moofluffy : did you paste the stored proc to the paste site?
<5> not that i actually care, you understand, i'm just curious
<4> haha
<4> i'll do that right quick, i only pasted the error earlier, not that you'll care ;)
<6> not quick enough, i fancy
<4> probably not
<6> good night all
<7> ola... Using MSSQL 2000 ... I have about 300 unique transactions that took place over the last 10 days... can anyone come up with a query whereby i could sum the entire day and output for the last 10 days?
<8> are you logging the transactions?
<8> or how do you know the last 10 days/
<7> yes with a timestamp
<7> datetime
<1> SUM() and GROUP BY
<7> i can easily do a select SUM(transactions) between jan 01 2006 and jan 02 2006, bit i can't think of how to output them by each day
<7> because each transaction though is a unique timestamp, the group by needs to be more broad to include the entire day
<8> so convert the datetime to just the day in your query and group by that
<7> i konw this is lame but i have scoured BOL on convert for datetime and just can't get it to output correctly can you display correct syntax
<8> nope, I dont use mssql
<7> k
<9> you need the CONVERT function iirc
<7> yeah i know i need to convert it.. i just can't understand how to use the datetime() convert function.
<7> BOL is really horrible for this
<9> whats datetime() ?
<1> CONVERT(DATETIME, CONVERT(CHAR(8), MyDateTime, 112), 112)
<7> cool thanks Halo_Four
<7> hey Halo, do you know how i can output Dec 19 2005 instead of this ? 2005-12-19 00:00:00.000
<10> mac_ by reading the documetnation for convert
<11> good evening all
<12> any .net 2.0 webhosting?
<13> Is there a way to change the display of null fields in a sql query output to say "no value" rather than just showing nothing?
<14> I believe you can use the function ISNULL(whatever)
<15> Depending on rdbms flavor: isnull(), coalesece(), nvl()
<14> true... most people refer to MSSQL as SQL. Drives me nuts.
<1> I believe COALESCE is ANSI
<12> yo
<12> in oracle
<12> i've stolen some data layer code and the connection string
<12> i try to connect from a differt computer and i get
<12> "could not resolve service name"
<12> do i need some client bull**** installed on the machine?
<14> normally
<12> like what
<14> SQL*Net and configure your TNS file at least
<12> SqlPlus or some****?
<12> ahhh
<12> can you link me?
<14> no
<14> paying bills right now
<14> :)
<12> arghhhh
<14> google man
<12> i need to be spoonfed
<14> then get your babyfood from somewhere else.
<12> jeepers
<12> i don't even know what to search for
<14> we'll lead you to water... but do the rest man
<14> TNS is a good search
<14> damn
<12> what's the datasource param of the connectionstring
<12> "data source=jjiz"
<12> is that DNS? no?
<12> DSN*
<12> or that alias in TNS
<14> 1 D 10 T
<12> wuts that killa
<14> thats why I'm gainfully employeed. :)
<12> rofl
<12> where to dl sqlnet
<12> i got OraHome81 instlaled
<16> yar
<12> wtf is orahome81
<16> oracle 8.1's home?
<12> meh
<3> you are running against an 8i server?
<3> id recommend the 9i client
<16> I haven't used oracle since around 5
<16> maybe 4
<3> yeah how old were you then?
<12> hye
<12> jarett
<3> 2?
<12> hmmz
<12> beleive it or not i need your help
<14> I'd believe it
<16> I don't believe it!
<12> i don't know what oracle is running
<12> i am guessing 8.1
<12> hehe
<12> anyway, i've got some code here, it has a connection string, i am not on the machine that this code is supposeta run
<12> i guess i need to setup a net8 listener?
<3> no
<16> listener?
<3> listener is only on the server
<12> oh
<16> yeah
<3> you need to edit the tnsnames.ora for the server
<12> ok
<16> yeah!
<12> where's that file
<3> but first you need to make sure the oracle home bin is in your path
<16> don't you know *anything* quant?!?!?
<16> I mean, jeez
<3> and open up dos and try to tnsping the server ip to make sure you setup the client right
<14> find is a good command
<12> rmah: nawt about oracle
<16> heh
<12> jarett, hold on, step by step
<3> d:\orant\whatever\8.1\network\admin
<3> the orant\whatever is where ever your oracle home is
<12> how can i make sure i have the client tools set up on this box i am on
<12> oracle home is what i need as far as the client goes?
<3> well that just is the default directory
<12> net8 configuration ***itance?
<3> dont use gui tools
<16> gui tools are for girls
<12> hehe
<3> ok you have an old client installed
<12> F:\oracle\ora81\network\tools
<12> that that?
<3> open up windows explorer. it is the little icon that looks like a folder
<3> network\admin
<16> haha
<12> ok
<3> open up tnsnames.ora in wordpad or notepad if on xp
<12> all i have is a sample dir in there
<3> that ****s
<12> move from sample to admin?
<14> this is going to take forever!
<12> inside sample dir i got that file which you talk about
<3> do you know the SID and ip of the db server?
<12> no i dont
<12> how to detect oraclez on the network?
Return to
#sql
or
Go to some related
logs:
terje unixhelp
#beginner
#gamedev
#windowsxp
pre-install modprobe.conf
kathem ha-7abeebi
#politics
#windowsxp
deferral: Unable_to_open_.qmail- :_access_denied._(#4.3.0)/
#gentoo
|
|