AdobeStock_455007340

or ?

is used to call stored-procedures. can be used to call stored procedures too. So which should you use? is simpler to use, but it does not support the use of multiple result sets, return codes, or output parameters. is a little trickier to use, but supports all of these. Plus, queries can be cached, queries cannot (for now). So, is a good choice for basic stored procedures (and for when you want to use query caching), is better suited for more complex stored procedures. (Applies to: ColdFusion 4 (or later))

One response to “or ?”

  1. skaplan Avatar
    skaplan

    Why doesn”t anyone mention that cfprocparam named notation isn”t supported with sql server or is it? Ben?

Leave a Reply