SQL update across the library seeks the maximum update, 2 to 1.-CodePudding

How will the following language combined into 1, 2,,,,,,,,

The update dbo. Xtshishi set
[face]=(select left (Max (sensorValue)), (4)
The from OpenRowset (' MSDASQL ', 'Driver=SQL Server; Server=172.16.110.39 \ sql2012; UID=sa; The PWD=ABC.. 123 ', KN. The dbo. KingWebSimulate)
Where PlaceName='face' and SensorName='high')
, [corner]=(select left (Max (sensorValue)), (4)
The from OpenRowset (' MSDASQL ', 'Driver=SQL Server; Server=172.16.110.39 \ sql2012; UID=sa; The PWD=ABC.. 123 ', KN. The dbo. KingWebSimulate)
Where PlaceName='corner and SensorName=' high ')

CodePudding user response:

I mean: this source can only write 1, from OpenRowset (' MSDASQL ', 'Driver=SQL Server; Server=172.16.110.39 \ sql2012; UID=sa; The PWD=ABC.. 123 ', KN. The dbo. KingWebSimulate)