|
-
March 7th, 2005, 08:28 PM
#1
Inserting multilple rows
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|