Hi,
This isn't strictly speaking a
Java issue, but I'm writing an application
using stored procedures to access a SQL Server database, and I have a
situation where I need to add multiple rows to a table (it's coming from a
multi-select list box). I'm wondering is there any other way of doing it other
that repeatedly calling the same stored proc to add them one at a time. Since
the values from the multi-select are part of a record, I'd like to be able to
insert/update the record in one go, rather than having to break it up into
multiple steps and then having to write a back-out procedure should any of
the steps fail.
Thanks for you help,
Kev