| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> [08:26] <1> but a join with is null is more index friendly for lookups then not exists... which almost always forces a full table scan
<0> huh, not in any version of MSSQL that I've ever used
<1> yes, but you are rather stupid... so what you say about tuning doesnt mean much
<0> spoken like a true blowhard EFnet unix-wannabe guru
<0> hehehe
<2> Petulant?
<0> not bad
<2> thanks.
<2> If I'm going to be a jerk, I like to know a variety of ways to describe it.
<0> I think the first time I heard that was on a monty python show in the 70s
<3> rjarett_ would make an excellent boy scout pack leader
<0> ...and it was in reference to the french! hahaha
<2> Mon deu
<4> ms sql2000, i'm trying create a backup script, that will create its own directories, and execure a few commands
<4> i'm trying to do it all in sql, rather than write 2 scripts
<4> ideas?
<5> yes i have an idea
<4> other than rtfm
<5> no
<5> rtfm
<5> and die
<4> a function name perhaps?
<5> go ask your butt buddies at #mcse
<4> i love you to mike
<6> whooooo
<7> what are you trying to backup?
<7> a database? all of the databases?
<4> all of them
<4> they will go into d:\backup\MMDDYYYY\DB.bak
<4> i just need to recreate that mmddyyyy on a daily basis
<7> so whats the problem
<7> so you need a script to create the name?
<8> mkdir mmddyyyy ?
<4> creating that dir from within the script
<7> CoJoNEs has it right
<4> mkdir in sql statements doesnt seem to work right
<8> its called a dos command
<7> theres a sp that can execute command statements
<4> there we go
<4> thats more like it
<7> I forget what its called but check books online for system stored procedures
<8> more like what?
<9> heh, it's an xp_
<4> yah
<7> yeah that too lol
<9> (might save some time looking)
<4> cmdshell
<4> xp_cmdshell
<4> w00t
<9> dingdingding
<4> ahh, just scratching the surface i am
<4> now comes the fun ****
<6> e-vad = troll
<4> yes mikep you are
<4> that is why you are banned from how many channels?
<6> 0..
<4> heh
<4> keep telling yourself that
<10> Does us all a favor, and go make out somewherei n private. We don't need to see this.
<11> hey guys, anyone have a good link on how to block against sql injections Using PHP5 and MYSQL latest
<8> *sigh*
<10> Use mysqli, use parameterized queries, and go ask in #mysql.
<8> sql injection really doesnt have anything to do with sql
<11> ya I know
<11> but figured you guys would know :P
<12> how do i update based on if a column in the same row is the greatest *after* filtering out the other parts of the where clause?
<8> and I figgured we hated mysql thats why we put it in the on join message
<8> phpwner that doesnt make sense
<11> oko
<11> thx guys
<4> one more
<4> can the USE statement be used with a variable
<4> say 'USE @db'
<4> or so
<13> CoJoNEsX hmm
<13> i want to select a row where the max of a column is equal to a subquery
<13> but mysql bitches: 'You can't specify target table 'kioskuse' for update in FROM clause'
<8> what is " the max of a column"
<13> SELECT * FROM T WHERE C1 IS NULL AND C2 = 1 AND C3 = MAX(C3); something like that
<13> but max can't be used like that being a group function
<10> having.
<8> im glad you can translate Drk`Angel
<13> i tried that, but mysql doesn't like max in a where clause
<8> you still need to use a group
<10> having.
<8> jasonmog HAVING
<13> i already tried but here i go again
<10> CoJoNEsX: I've worked with a lot of idiots. I've had to learn how to translate. :/
<14> hey
<7> hey..
<8> show me you tried and show me the error
<14> no MySQL? Are you seroius? That's what I need help with :(
<14> serious*
<7> #mySQL
<8> qpt #mysql
<14> oh
<14> thx guys
<14> bubbaNACH: hi
<15> hi
<15> ****ers glined me
<15> shut the hell up nyquil
<15> quit noticing me
<15> wow someone woke up on the wrong side 0f the bed
<8> I was thinking the same thing
<15> prolly woke up with a sore *** covered in vaseline
<7> man I <3 visio
<10> ...
<7> . .. . . . ... . . .. . .. .. .. . . . . . . ...... . . .
<7> the ants go marching one by one hooraaaahhh horraaahh
<8> I think I make friends in here every day
<4> any way to use 'USE @dbName' with out using exec?
<9> yes, you can use it as is. if "working" isn't one of your requirements
<4> 'yeah, that line will work even better if you put -- infront of it
<0> FOR /F "tokens=2-4 delims=/ " %%d IN ('date /T') DO set today=%%f%%d%%e
<0> MD %today%-%CURRENTTIME%
<0> for all you DOS heads out there
<0> oops for got this one before you make the dir
<0> FOR /F " tokens=1,2* delims=: " %%i IN ('time /T') DO SET CURRENTTIME=%%i%%j
<0> isql -Uthisuser -Pthisp*** -dmaster -Q "select getdate();"
<13> CoJoNEsX am i your frien
<13> d
<0> ... so put that in your batch file and smoke it!
<0> heh
<0> and if that doesn't give you any ideas e-vad, you need to learn how to read code you didn't write
<6> e-vad you have come back my nemsis
<6> nemesis
<4> Guest2: got that part sorted
<4> now i am trying to use use statements with variables
<6> my life ****s
<6> hey e-vad
<4> that is not fixing my sql problem
<0> you don't get it you don't need xp_commandshell or whatever you can do it all on the OS side, even scheduling back ups
<4> Guest2: yes... i know that
<0> open up a cmd window and type isql /help or something
<4> i was hoping not to have to write 2 scripts, one .bat, and 1 .sql
<4> xp_cmdshell saved that
<0> I've been doing that sorta stuff since 6.5 still works great
<0> well, nevermind
<0> I'll let you wade through all that on your own
<0> once upon a time, all sysadmins knew how to script, these days you're lucky if a 'developer' can write anything without 5000$ worth of tools
<0> ...and sysadmins can't do anything without GUI... really, what has this world come to
<7> operating costs and accountability
<0> indeed, you had better produce some really radical **** with all those tools geared to creat text files.....HAHAHAHAH
<0> you can't use the bean counter argument here, really
<7> sure you can
<7> because thats what it always boils down to
<9> Guest2: i just spent about a half hour walking through dos/windows environment variables with a developer
<9> wowing with commands like echo, set, if..
<0> well you can try, and many do, but 5 years later when thier biz is going belly up and they wonder where all the money went and where the hell is the product...well
<0> heheh phargle, funny its a lost art, and the most stable systems I've built are with that stuff... like 'cron'ing' with the at command, etc.
Return to
#sql
or
Go to some related
logs:
#eggy
#ubuntu
nerp propeller
#windowsxp
chbind: vc_xidopt2xid
#flash
#nhl
#windows
SamplingProfiler
wallpaper suzuki gsr600
|
|