如何將下面2條語名合并為1條。。。。。。。
update dbo.xtshishi set
[作業面]=(select left((max(sensorValue)),4)
from OpenRowset('MSDASQL','Driver=SQL Server;Server=172.16.110.39\sql2012;UID=sa;PWD=abc..123',KN.dbo.KingWebSimulate)
where PlaceName='作業面' and SensorName='高')
,[隅角]=(select left((max(sensorValue)),4)
from OpenRowset('MSDASQL','Driver=SQL Server;Server=172.16.110.39\sql2012;UID=sa;PWD=abc..123',KN.dbo.KingWebSimulate)
where PlaceName='隅角' and SensorName='高')
uj5u.com熱心網友回復：
我指的是：這條來源能否只寫1條，from OpenRowset('MSDASQL','Driver=SQL Server;Server=172.16.110.39\sql2012;UID=sa;PWD=abc..123',KN.dbo.KingWebSimulate)轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/283612.html
標籤：疑難問題
下一篇：產品BOM類問題