Stored Procedures
Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Web Application Development Tips and other Web Development topics.
Stored Procedures
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.
| Guru Spotlight |
| Candi Wingate |
