Sql updating multiple tables

Even if you do write a "updatable" view (which is simply a view that follows certain restrictions), updates like this will fail.

sql updating multiple tables-8

Regardless of that, you still need to do two separate updates.probably not related: this won't work on MYSQL because the update syntax for mysql is different.You can additionally use MERGE statement to do the same as well, however I personally prefer this method. Let us clean up the clause by dropping the tables which we have created.performance wise I liked; (not my! guess you already covered it somewhere..; WITH CTE AS (SELECT T1. ORG_ID = @ORG_ID COMMIT BEGIN TRANSACTION is not the same as BEGIN which starts a block ( used in IF for example).And I agree about the hack-i-ness of the suggested link (I might even suggest removing it).