In most cases it isn't necessary. There is a speed benefit gained on the server by caching its execution plan.

Then you just issue a SqlExec without any arguments.

Mainly, you would use it for a
Scan ... Insert

for instance if you didn't have bulk insert rights.

I ran into this at a couple of client sites.

>I have never used SqlPrepare and I don't think I have missed much??
>
>About two years ago I rebuilt all my data handling classes to use SPT. I roll by own update, insert, delete statements. I have not used a DBC in that many years and I really can't see that I have missed it (DBC).
>
>>TextMerge is also recursive as well. It handle local variables and local parameters just fine. That's much better than the SPT parameters.
>>
>>But SqlPrepare would still requires the parameters, correct?

>> snip >>