I'm just annoyed because I missed the closing paren on the second one - no far reformatting the SQL!

--woody

Back in the dawn of of the .COM era BUY listed 21" monitors at the unheard of price of 150$, or something like that.

Turned out it was an oopsie and...

I think I"m confused - if you do a restore don't you loose ALL the changes following the mistaken update?

Wouldn't that be a bad thing?

--woody

OK, nobody's gotten this right  and nobody's said anything about it?

Actually, I don't have anything to say either, I don't even know why i'm...

Why don't people suggest using debuggers on stored procs?

My experience is - until recently (recently being the debut of Sql2k) they just didn't work ...

bits? ewww....!

--woody

I usually just try to answer these things (or guess) without BOL or google but that one was so of-the-wall I resorted to Google to find it ....

now THAT is obscure...

--woody

<

+ anyone ever heard of any sales guy ever using Query Analyser? It would be like an amoeba driving a car!

>

I've worked at places where they've let trained (or...

ouch, my brain hurts - and worse yet I'm STILL not sure I understand it 😉

--woody

C. Woody Butler, MCP

cwbutler@cebec.com

How does that play with connection pooling? I always understood that the connect strings had to be identical, and if you've got computer name in there I'd think that'd mess...

use sp_executeSql - if you fully qualify the dynamic sql in the SP SQL Server will precompile and bind if you rexecute the same statement multiple times...

--woody

C. Woody Butler, MCP