Friday, February 24, 2012

"batch size setting" ?

Is there a "bacth size setting" or some such t-sql option that determines the number of records sql will hold before commiting them as a group to the database?

TIA,

Barkingdog

Not that I know of, but you can use marshalling by setting up a loop and tellng it to commit.

No comments:

Post a Comment