Updating multiple tables in mssql rahsaan patterson dating
Other than doing it in a loop from eg asp, over either fields (one statement per field), or over records (a query with a loop which for each row does a select from one table, update other table with the selected values.) You can use the proprietary UPDATE...
FROM syntax: UPDATE T1 SET the Updated Value = T2Top, the Other Value = T2Value FROM T2 WHERE T2Key = T1ID Or with an alias: UPDATE a SET the Updated Value = Top, the Other Value = Value FROM T1 a JOIN T2 b ON Key = ID -- Hope this helps.
Here are the results of some tests made on a 316,878 records database using both My ISAM and Inno DB storage engine.
Should any right be infringed, it is totally unintentional.