>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?