SQL server caching mechanism has been enhanced and stored procedures are not always the faster way to do something. And one is not always allowed to create stored procedures on a DB.
scatter-gather or append blank-replace vs insert into is debatable in VFP. For SQL server you might either use insert into or stored procedure as you wish (there are tendencies where people create a stored procedure that would either insert or update a row). When it's multiple insertions then neither might be the answer, depends. ie: If you'd insert 10 rows then you might wrap that 10 insert into statements into a single batch via SPT. Or you might create a table buffered SPT cursor make your insertions and than do a single tableupdate() etc.
Cetin
>just a general query, in VFP, which all of our data is held in at the moment, we either use, scatter-gather or append blank-replace field with... Can you use a stored procedure to do same or is there a better way to add a record to SQL from VFP code.
>~M
>
>>I Agree.
>>
>>
>>SQLEXEC and STORED PROCEDURES together are faster and very comprehensive way to do your job.
>>
>>Carlos Burgos