Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Update master-detail with one store proc.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-08 : 15:35:11
JPoul writes "Let's say I have a master-detail form, say order and products. I need to update the data by using stored procedures. As I want to minimize the work load from the client, I would like to have one stored procedure to do the updating - maybe use a nested one for the products. But how can I pass the values of the products' data? Should I use arrays? Which is the best way to implement such an update?"
   

- Advertisement -