newbie-do i need multiple updates queries to update multiple tables? 1

[azarcomp]

Ok, well I am trying to narrow it down before I start coding it for the development app, this is not the dev tables or data.just trying to see if someone thinks i am on the right track.

now I am trying to figure out if the only and best wat to update into 2 or more tables at the same time is to use 2 or more update queries.

like so:
1.make the updates for each table
update Customersset Name = 'TwinBob'where customerId = 1;update dbo.addressset Street = 'newstreet Rd'where CustomerID = 1

--Below select just to view my update changes--select c.CustomerID,c.Name,a.AddressID,a.Street from Customers c left join address aon c.CustomerID = a.CustomerID

am I on the right track???

2. Then make parameters for each column of each table and make the whole batch a stored procedure (T-sql).

3. Then in VB.net pass the vales of columns to be updated to the stored proc from vb.net.

Thanks VERY much in advance

 

[markros]

Sounds like correct approach to me.

PluralSight Learning Library

 

[azarcomp]

thanks, some times you just would like some reinforcement before you spend a couple hours using the wrong approach to begin with. thank!

 

[markros]

One more thing, I forgot - if you need both updates to succeed or both fail, you need to wrap these two updates in transaction.

Here is an example for inserts, but the idea is the same:

How to insert information into multiple related tables and return ID using SQLDataSource

PluralSight Learning Library