IN THIS CHAPTER
Most server-based database systems—SQL Server, Oracle, and MySQL—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. After the stored procedure has been created, you can invoke it in your ColdFusion templates using the
The use of stored procedures in database applications is a relatively advanced topic. It’s not rocket science, but you will be more comfortable working with stored procedures if you are familiar with the SQL concepts introduced in the previous chapter or have ...