CODEWITHSUNDEEP
sql
siva
siva

Reputation: 107

update two or more tables with the single statement

How do i update two or more two tables without the help of where clause.

Thanks...

Upvotes: 2

Views: 246

Answers (2)

HLGEM
HLGEM

Reputation: 96552

In SQL Server you cannot update two tables in one update statement even in an updateable view.

Upvotes: 0

Bharat
Bharat

Reputation: 6866

You can do this by using an updateable view and instead of trigger.

For this you need to create a view on your base tables and add an "instead of" trigger to this view

Later you can update the view directly.

For more information check the following links

how to update multiple tables in oracle DB?

Update multiple table column values using single query

Upvotes: 2

Related Questions