: How to batch update two joined table data: SQLServer joined table

: How to batch update two joined table data: SQLServer joined table

This example describes how to update two joined tables in batches by SQLServer. We will share this with you for your reference. The details are as follows:

Method 1:

UPDATE a SET WtNo = B. NOfrom WT_Task aINNER JOIN WT_BasicInformation B ON a. WtId = B. ID;

Method 2:

UPDATE a SET a. WtNo = B. NOFROM WT_Task a, WT_BasicInformation bWHERE a. WtId = B. ID;

I hope this article will help you design SQL Server database programs.