Updating multiple tables in mssql

Should any right be infringed, it is totally unintentional.Drop me an email and I will promptly and gladly rectify it.Inno DB As you can see the results are very interesting.You can clearly see the difference of both storage engine and transactions (at least for My ISAM).

Suppose we have two tables Categories and Categories_Test. The common column in the two tables is CATEGORY_ID. Please note that query below is used for illustration purpose because Category_ID alone is primary key.

Also, keep in mind that in order to gain advantage of My SQL optimizations all those UPDATE queries need to be run in a batch.

Running each UPDATE query when the page is viewed for example is not the same thing (and that’s pretty much the problem I wanted to solve as efficiently as possible).

Also, as a final note, you should always run an OPTIMIZE TABLE query after all these updates.

update T1 set (the Updated Value, the Other Value) = (select the Top, the Value from T2 where T2Key = T1ID) Is there a workaround?

Search for updating multiple tables in mssql:

updating multiple tables in mssql-26updating multiple tables in mssql-45

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating multiple tables in mssql”

  1. Sexcamly’s couple cams are the hottest and most diverse live sex cams on the internet. Live sex cams have been dubbed the ‘future of porn’, due to the flexibility and excitement of watching live sex.