General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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 >>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only