Comment On sp_hi()

As one of my final projects at work, I'm maintaining an application provided by another vendor. I honestly believe that this is the worst software ever written. From personalized comments (“Mike emailed me, thought we should change this method, so I'm changing it, but I'm not sure why“) to an incredible variety of platforms (VBScript/JScript/C#/VB.Net), this has it all. Including this stored procedure in the main SQL Database: [expand full text]
« PrevPage 1Next »

re: sp_hi()

2004-08-20 00:13 • by John S.
Hello world was too many characters to echo

re: sp_hi()

2004-08-20 00:18 • by Harlot
WTF mate?

re: sp_hi()

2004-08-20 00:24 • by Peter Hancock
I liked the typo....

"asdfasf"

Where'd the 'd' go? I can understand now why it had to print hi.


Although I can understand personalized comments. I HATE with a passion when I'm told to do something but don't know why. I usually put a comment like that in code. It's called
cover your arse.

You know - along the lines of
/* This is a hack to write a log to a temp file and MUST be removed for production, but I bet it doesn't and ends up crashing the server when it runs out of disk space */ :-)

re: sp_hi()

2004-08-20 01:45 • by Pope Terry
Some coders get lonley and need someone to talk to. Some go out and meet up with friends, some write procs to talk to them!

Anyway, at least he/she didn't actually call it sp_hi....

re: sp_hi()

2004-08-20 05:27 • by AT
Common practice in my company...

re: sp_hi()

2004-08-20 10:49 • by Tim Cartwright
hmmmm, one issue with this is that the "hello world" aspect would only work from
query analyzer, T-SQL PRINT statements are un-retrievable from client side code.
ADO or ADO.Net. So, I guess the fact that the proc ran from the client was good
enough to ensure connectivity?

re: sp_hi()

2004-08-20 11:59 • by Brian
Doesn't the SqlConnection.InfoMessage event allow you to get PRINT statements?

re: sp_hi()

2004-08-21 22:56 • by Bill
Please Please Please post more of this code.



Brian - yes, InfoMessage will print error messages - supposed to only print errors w/ severity < 13 (or maybe it's 11) but Print statements will show even though they aren't errors.

re: sp_hi()

2004-08-24 03:21 • by Gregg
Hey! It's my code! ... Err... nevermind *hides*

re: sp_hi()

2004-08-24 05:43 • by Brady
Who added the sp_ prefix?

re: sp_hi()

2004-08-24 18:39 • by Tim Cartwright
Thanks Brian, and Bill, I was not aware of that event.

re: sp_hi()

2004-08-26 02:37 • by aim48
It's a hidden easter egg. :-)
Submit to www.eggheaven2000.com

Re: sp_hi()

2011-01-23 21:15 • by cindy (unregistered)
find for all kinds of watches and handbags .
A Lange & Sohne watches
Audemars Piguet watches
Ulysse Nardin watches
Vacheron Constantin watches
Michele Watches
Ebel watches
And so on

http://www.replica038.com
« PrevPage 1Next »

Add Comment