I guess that you won't see a difference either way. sp_executesql tries to parameterize the queries and create a query plan that can be cached. There are specific rules that must be followed. Karen Delaney covers this pretty well in her book Inside Microsoft SQL Server 2000.

Basically, you're supposed to get good results from sp_executesql when just your parameter values are changing, not the query structure.

-Mike