>>I only use the sp_executesql when I've to execute dynamic SQL and return value(s) to the calling code. I don't remember ever using it from SSMS directly.
>
>Ok, based on your other message, basically, if sp_executesql makes a better use of the execution plan, then, would it be better to use this approach instead of using the SQLParameter object to create parameters and use a regular SQL command through the SQLClient data provider to access SQL Server?
Not sure for NET, but when in VFP I use parameters in my queries VFP explicitly use sp_executesql to run this query.
Just run SQL Profiler and see what command is send to SQL Server when you use parameters.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
