November 3, 2003 at 4:37 am
Hello,
I was wondering if it is possible to update multiple tables simultaneously in an SQL Server 2000 Database using ASP?
Thanks
November 3, 2003 at 5:11 am
Depending on your needs, you could use 'updateable views'. Some restrictions apply, so you should check them against your needs.
Another solution (f you don't want to use multiple recordsets) is to use a stored procedure to do the updates.
November 3, 2003 at 5:31 am
The main problem is that I am updating the database with multiple values that are recieved in a form...possibly around 20-30. Would using something like a stored procedure to update this not require the values to be passed in through the asp page as paramaters? What would be the performance issues of this?
November 3, 2003 at 6:21 am
I guess from both performance and security point of view you should go for a stored procedure.
Yes, of course, you'll have to pass your parameters to that procedure, don't worry about 20 or 30 parameters. With SQL2k you can use up to 2,100 parameters.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 3, 2003 at 6:34 am
The last time I did something like this was to use a same name for the fields which results in an array of results. I then use the length of the array to determine how many times to call a standard proc and pass each value in turn. Therefore you can increase/decrease the number of fields without changing the processing. With checkboxes you only get the values of checked boxes so beware.
Far away is close at hand in the images of elsewhere.
Anon.
November 4, 2003 at 8:52 am
Great,
Thanks a lot for the advice.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply