Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Why do people use numbered procedures?
Old 03-06-2008, 04:47 PM Why do people use numbered procedures?
Learning Newbie's Avatar
Defies a Status

Latest Blog Post:
Astounding Republican Paranoia
Posts: 5,662
Name: John Alexander
Trades: 0
I have to fix a giant mess now. Not that I'm complaining, this keeps hte paychecks coming in. But still - I guess I'm complaining a little.

Client wants all their numbered procedures changed to a new style, to be determined. They apparently ignored the writing on the wall until upgrading recently to SQL 2005 and now that the feature is deprecated and scheduled for removal, it's got to be fixed.

They suggested changing dbo.ProcedureName;N to dbo.ProcedureName_N which will be easy for them to adapt. I'm not sure why this style of coding wouldn't have been used from the outset? The only reason I could think of would be using real names instead so you can look at your database and understand what it does.

Anybody else run into this?
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
Learning Newbie is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 03-06-2008, 06:25 PM Re: Why do people use numbered procedures?
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
Yeah, I did...

But mostly, it was that the job was taken backward at first.
IE: first programming, then the analyze, and it resulted in a lot of copy/paste.
Or at least, it's how it seemed.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Reply     « Reply to Why do people use numbered procedures?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.09653 seconds with 12 queries