Is it possible to update two tables with a single statement?

microsoft.public.sqlserver.programming

19 May 2006 5:06 PM

Matthew Speed

I have a feeling this isn't allowed, but is there any way to update columns
in two different tables through a join in the update syntax?

TIA

19 May 2006 5:13 PM

Alexander Kuznetsov

you can issue an update statement against a view and do any
modifications behind the scenes via an INSTEAD OF trigger

19 May 2006 5:15 PM

Omnibuzz

No you can't :(

Show quote

"Matthew Speed" wrote:

> I have a feeling this isn't allowed, but is there any way to update columns
> in two different tables through a join in the update syntax?
>
> TIA