Is there any performance difference between the two approaches when using especially large (200 or so input variables) SP's?
Pete On 6/5/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > On 6/5/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > Title says it all. Using MS SQL Server, how do you call a stored > > procedure using the CFQUERY tag? > > Take your normal call from Query Analyzer and paste it into a CFQuery. > <cfquery name="whatever" datasource="however"> > EXEC your_procedure_name @Parmeter1 = #Parameter1Value#, @Parameter2 = > '#Parameter2Value#' > </cfquery> > > However, you're probably much better off using the CFSTOREDPROC / > CFPROCPARAM tag set... it does validation and handles procedures quite > nicely. > > HTH > Hatton > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
