[EMAIL PROTECTED] wrote:
If you have 100 columns, then you really need to consider normalizing.
One more thing. Make your SPs named according to the namespace of the
code your writing. As your systems get big, and your dealing with 1400
+ SPs, it's the only way to make any sense! I still have a couple of
hundred of the "usp_"?????????? files and they are all SPs, well no
shit.
Good points...thanks, Steve. There's not many columns, so I'll consider
that. As for naming conventions, you're right. I wish there were
"packages" in SQL Server like there are in Oracle. The Oracle packages
allow you to organize a bit better, imo. Why M$ never adopted that, I
can't understand why (unless it's a copyright issue or something)??????
--Michael
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
