Update associate other tables to Update data in batches-Cross-database-Cross-Server update

1. Sometimes there will be some initial data updates during the project, from the old system to the new system. If the application is cyclically paid from the old system to the new system. 2. The following method may be used when a synchronization program is required in a project or when a large amount of data is updated automatically. 3. for analysis, you need to integrate some data into a table, which involves associating with the primary key.

1. Sometimes there will be some initial data updates during the project, from the old system to the new system. If the application is cyclically paid from the old system to the new system. 2. The following method may be used when a synchronization program is required in a project or when a large amount of data is updated automatically. 3. for analysis, you need to integrate some data into a table, which involves associating with the primary key.

1. Sometimes there will be some initial data updates during the project, from the old system to the new system. If the application is cyclically paid from the old system to the new system.

2. The following method may be used when a synchronization program is required in a project or when a large amount of data is updated automatically.

3. for analysis, we need to integrate some data into a table, which involves associating multiple tables with the primary key to obtain the values of some of the fields. We can simply implement it through update. I found an article, pretty good:

When updating tables in batches, when updating columns in a table, you must depend on another table. This dependency can be a where Condition Clause or the field value to be updated depends on another table.
There are usually two methods
1. Use stored procedures
2. Execute them one by one in the program code
3. There is a more efficient and concise way to update SQL statements in batches. One SQL statement can replace the troublesome cycle process, which can be written in MS SQLServer, Oracle, and DB2.

UPDATE kcm02 SET kcjhcb = V_U8_Inventory.iInvRCost, kccbhs = 1_v_u8_inventory WHERE V_U8_Inventory.cInvCode = kcm02.kcwpdm