Stored procedures are precompiled SQL statements that are stored in a database and executed at run time. Each database has its own stored procedure syntax that can be sent from ColdFusion using a <cfquery>. A more powerful interface for stored procedures is the <cfstoredproc> tag. This tag has an end tag and takes two possible nested tags: <cfprocparam> and <cfprocresult>. <cfprocparam> can send and receive parameters, whereas <cfprocresult> was built to expose result sets as ColdFusion record sets. Sample Questions
|