January 8, 2010, Newsletter Issue #85: Stored Procedures
Tip of the Week
If you are using a database, try to use stored procedures instead of inline asp database code.
Stored Procedures are scripts that are run on, owned by, and specific to your database. They generally reside IN your database files. If you have ever looked at a very large asp file (I have seen rediculously large 2000+ line asp files - complete with functions, html, database calls, sql text, style information, etc.), and I will tell you it is not pretty, nor is it easy to change, maintain, edit, or even follow. If at all possible, don't have inline sql. If you can access the database, and use stored procedures, not only will it make the code easier to follow, but you'll never have to dig into the code again to make data changes - simply edit the stored procedure on the database, or the function call you create that calls the stored procedure. For a better example, see www.meridiandevelopmentsystems.com/lifetips/05.htm.
About LifeTips
Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.
| Guru Spotlight |
| Candi Wingate |
