| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> why does your stored procedure have to be temporary?
<1> haha
<1> he's a dillweed
<0> I perfer to have a real stored procedure that is smart enough to work properly
<2> because it references objects created temporarily
<3> phargle : the whole point about a stored proc is to be pre-compiled
<0> Microsoft recommends to use the temporary stored procedures when connecting to earlier versions of SQL Server that do not support the reuse of execution plans. Applications connecting to SQL Server 7.0 or SQL Server 2000 should use the sp_executesql system stored procedure instead of temporary stored procedures to have a better chance to reuse the execution plans.
<0> there
<0> I dont even use MSSQL and I knew it was a bad idea
<2> pre compiled doesn't mean ****.. this isn't going to run multiple times per second
<0> <@CoJoNEsX> that pretty much defeats the purpose of using a stored procedure
<2> caching the execution plan isn't important.
<0> yes it does
<0> it has to load the sp first
<1> phargle is a ****ing moron
<0> and bump something out of memory, then execute and bump it back out
<4> phargle why would you want to ever dymanically create sprocs?
<2> i explained it
<4> why not either 1) just dont. or 2) just make it persist
<1> cause he think she write good for loops
<0> your explaination is crap
<1> he*
<1> stupidest explanation ever
<4> yea your explanation doesnt explain anything
<2> oi
<2> nm then.
<0> I use a copy of my data so I can call it multiple times and use reusable data
<0> do you see how silly that sounds?
<2> thats what i do to.
<2> but i don't write multiple statements in this case to work with the data
<0> why would you?
<1> reusable = created once and used elsewhere
<1> your **** is not reusable
<2> ad i dont need to go back and change sql based on data changes
<0> you are still not making sense
<0> that last one is just being lazy..
<4> hmm can you p*** a table variable into a sproc?
<1> yes
<0> and you still dont need a temporary proc for that
<1> i think to UDF u can
<2> from UDF you can get a table.
<2> you can't p*** a table variable to a sp.
<0> you mean like a record type?
<5> [ms sql2000]:: is it possible to get the IP address of the host?(the host computer from which user is connecting to database)
<5> well, "sysprocesses" only seem to display name of the host computer but not the IP
<3> d2d_w0rk : why do you need to?
<4> d2d_w0rk have the client p*** it in
<5> wouldn't it be fun to store IP addresses?
<5> hmm that's the problem. I don't want the client app to p*** the IP information
<5> so I was originallly trying to store HOST only but i think retrieving IP information can be also useful and as well as being fun
<4> for what purpose?
<5> GuntherX:: why break anything when something's working?
<4> i don't think there's a way btw
<5> why? hmm
<4> isnt this why db logs exist?
<4> or have the client p*** it in
<4> (like everything else)
<0> it does sound like fun and all, but ****ing hell why?!
<5> but then, suppose that you have a table "t1" and would like to have "insert" trigger on "t1".
<0> shell out and do a nslookup maybe
<5> and i would like to have that trigger to retrieve the IP information of the client connection and write that info somewhere else
<4> you mean like
<4> a database ... log
<4> if only there was some way
<0> heh
<5> well but what i don't get is that, if MS sql 2000 can somehow retrieve "host" information, why can't it give me an IP... :)
<2> host name is supplied by the app in the connection
<5> well i was actually looking through extended sprocs but there doesn't seem to be one
<0> well contact microsoft :)
<0> and ask those bitches why?
<5> hmm i see... i guess the QA sends the host information
<5> well maybe i should! :) as long as i remember about this when i get home
<0> hah
<0> it wont be fun when you get home
<5> well said! CoJoNEsX!
<0> work is only fun when its not the work you need to be doing at work
<5> i know :)
<5> i might just play around with MSH/Monad when i get home not on this
<5> anyways, nice talking to ya folks. i am heading home
<4> later
<4> http://cgi.ebay.com/DEMON-IN-A-JAR-WEIRD-FARTS-PEES-ALL-OVER-CUSSES_W0QQitemZ9504487216QQcategoryZ1469QQssPageNameZWDVWQQrdZ1QQcmdZViewItem
<6> Is there a way to use LIKE to match strings containing only A's for exemple? I dont see how do have a "variable length"
<4> how about LEN(REPLACE(LOWER(str), "a", ""))
<4> if that is > 0, then the string has characters other than A or a in it
<6> u mean to do a function?
<4> with a l33t vhost like yours, i would expect you to already understand what i said
<4> damn he left
<7> huhu
<8> I'm using sql server 7.0 is there anyway of choosing the "Month name" out of a datetime column (e.g. February)?
<4> you can get the month NUMBER
<2> pilabyte: yea there is
<2> like datename or something
<9> How do you determine when to use a return value or RAISERROR?
<10> heh
<10> return value is for returning things to other things. raiserror is mostly for errors
<9> tx
<10> that couldn't possibly have helped you
<11> LOL
<9> that is kinda funny
<12> heh
<13> ninjajax: you here?
<11> oui.
<13> i can't get my reg code to work
<13> for your site =/
<12> was that funny too?
<11> So when it comes to the register4.php page, does the image below the textbox not show up?
<13> yea
<13> nothing there
<13> i'm using firegox
<13> if that matter
<13> firefox =/
<11> if you go to the http://www.myprizes.net/register.php page
<11> do the vlaues fill in for all the main fields?
<14> you are making a scam site?
<13> ?
<13> it's blank
<13> you mean if i type them in?
<11> hmm, they shouldn't be blank if you typed them in once.
<10> yeah that's got lame and scam written all over it
<11> unless you have cleared your ccookies.
<11> Jarett_ & Mixx It's a legit site.
<14> sure it is
<14> so is freeipod.com
<14> yep...
<11> I don't like freeipod :/
<11> although call for help did do a segment on it
<14> may you get testicular cancer before people get their "freeipod"'s
<13> ah
<13> now that i'm using IE
<13> it's working
<12> all hail IE!
<11> which version of firefox are you using?
<11> If you don't mind me asking. :)
<12> are you an ajax ninja?
<13> 1.0.7
<11> No, I just have ajax in mynickname becuase I thought it was very funny when I would help people in #javascript, and then have them be kickbanned for saying my name in thanks.
<11> jim: thanks, I'll do some trouble shooting on that browser.
<15> can I ask XQuery questions in here?
<16> no
<17> What datatype shall I chose for a percentage-factor, ex: 0.09 (mssql
<16> ioNix_ depends on your precision you need
<17> maximum 2 decimals
<17> 0.01
<17> 0.01 - 1.00
<18> i want to do basic arthimetic in 10g ie select foo-bar as foobar from test where foobar > 0
<18> is that right syntax
<16> then use a decimal datatype what's the prob
<19> there is no master database by default in msde 2000?
<19> it looks like there should be.
<19> yeah nm.
Return to
#sql
or
Go to some related
logs:
#c
kz_hideandseek explanation
Dell Latitude D800 Power Button broken
#politics
solid mucous
resha howard
#politics
#hardware
rotting skin
heroes 2 gold crack
|
|