SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Pastimes : Silicon Investor, under the hood

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: SI Bob who wrote (1)12/12/2004 8:32:23 PM
From: TGPTNDR  Read Replies (1) of 81
 
HI Bob, Re: <But a pet peeve of mine (reading this, Dave?) is using stored procs for routines that are called relatively rarely and wouldn't run noticeably more slowly or expensively with T-SQL. It's because, to me, the tiny performance gain from making SP's for everything isn't worth the cost in my annoyance and productivity when having to scroll through hundreds of SP's to get to the one I want to edit.>

LOL!!

Build a batch job to select the SP out of the database into your word editor and another to save it back to the database.

You are really doing things the hard way.

Additionally, you should have all your SPs as individual flat files readable into the DB by a batch file. How'n the hell would you recreate a new DB without such a process?

-tgp
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext