From my web app, I need to write changes back for ten rows at a time. Right now, I am running my single row update procedure 10x. I would like to populate some sort of array or recordset and pass that to my procedure as a parameter and then update them all at once. Any Ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating multiple rows
- Thread starter cre108
- Start date
loschiavoj
Programmer
I did this with a file.sql and called it as STA "c:\file.sql"; In the file i had a total of 100 update statements. Hope it helps.
- Status
Similar threads
- Locked
- Question