mantony
March 7th, 2005, 07:28 PM
Hi Gurus
need a little help with ADO.net and SQLServer 2000
what is the best way to insert 100+ rows periodically.
1. should we use a stored proc?? if so how do we batch it up.
2. should we use a dataset and add new rows to it and finally call update.
we need high insert performance
please help with your reccomendations
regards,
melvin
need a little help with ADO.net and SQLServer 2000
what is the best way to insert 100+ rows periodically.
1. should we use a stored proc?? if so how do we batch it up.
2. should we use a dataset and add new rows to it and finally call update.
we need high insert performance
please help with your reccomendations
regards,
melvin