Viewing 12 posts - 1 through 12 (of 12 total)
I'm just annoyed because I missed the closing paren on the second one - no far reformatting the SQL!
October 21, 2004 at 8:56 pm
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...
August 27, 2004 at 7:18 am
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?
August 27, 2004 at 5:08 am
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...
July 26, 2004 at 10:33 pm
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 ...
July 8, 2004 at 10:06 pm
June 13, 2004 at 10:18 pm
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 ....
January 16, 2004 at 3:30 pm
now THAT is obscure...
January 15, 2004 at 9:49 pm
+ 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...
December 9, 2003 at 5:34 am
ouch, my brain hurts - and worse yet I'm STILL not sure I understand it 😉
C. Woody Butler, MCP
August 12, 2003 at 8:13 pm
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...
September 22, 2002 at 3:28 pm
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...
September 8, 2002 at 9:00 pm