Update multiple tables

[DH]

In Access I can create a query with multiple tables and update multiple tables within the query.

In learning SQL Server I have read that in SQL Server you can only update one base table within a view.

I am new to SQL Server and wondering how to update multiple tables?

Can someone explain or point me in the right direction.

Also, does anyone have any book recommendations regarding learning and getting upto speed with SQL Server 2000?

Thank you.

DH

 

[SQLSister]

Useful Reference Books for SQL Server Professionals faq183-3324

What I do is put all the individual table updates into a stored procedure with transaction processing so that if one fails all are rolled back.

Questions about posting. See faq183-874