• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part IV: Advanced ColdFusion > Working with Stored Procedures

Chapter 20. Working with Stored Procedures

In this chapter

Why Use Stored Procedures?

Calling Stored Procedures from ColdFusion Templates

Creating Stored Procedures

Most server-based database systems—SQL Server, Oracle, and Sybase—support stored procedures. A stored procedure is a chunk of SQL code that's given a name and stored as a part of your database, along with your actual data tables. Once the stored procedure has been created, you can invoke it in your ColdFusion templates using the CFSTOREDPROC tag.

Tip

The use of stored procedures in database applications is a relatively advanced topic. As the saying goes, it's not exactly rocket science, but it probably makes sense to start working with stored procedures only after you have become pretty familiar with the SQL concepts introduced in the previous chapter, or have a specific reason for using stored procedures in a particular ColdFusion application.


Note

At the time of this writing, stored procedures are supported by most server-based database systems (such as SQL Server, Oracle, and Sybase), but are not supported by any file-based databases like Access, FoxPro, Paradox, dBASE, and the like. If you are not using a server-based database system, you can skip this chapter without missing out on anything essential.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint