UC知道一个更新语句出错了，请明白人看看
来源：百度知道 编辑：UC知道 时间：2024/06/17 20:45:03
update asset.dbo.assetChange set (aID,atID,aCode,aSerise,aSpec,aProvider,aMainList,
aCDList,aBetteryList,aProTime,aNum,aDate,aRemark,aCPU,aDisk,aRam,State)=( select aID,atID,aCode,aSerise,aSpec,aProvider,aMainList,
aCDList,aBetteryList,aProTime,aNum,aDate,aRemark,aCPU,aDisk,aRam,State from inserted)
消息 102，级别 15，状态 1，过程 Trigger_Update，第 15 行
'(' 附近有语法错误。
aCDList,aBetteryList,aProTime,aNum,aDate,aRemark,aCPU,aDisk,aRam,State)=( select aID,atID,aCode,aSerise,aSpec,aProvider,aMainList,
aCDList,aBetteryList,aProTime,aNum,aDate,aRemark,aCPU,aDisk,aRam,State from inserted)
消息 102，级别 15，状态 1，过程 Trigger_Update，第 15 行
'(' 附近有语法错误。
更新语法就不对，字段比较多，我就拿前几个字段举例
update asset.dbo.assetChange
set aId=inserted.aId,atID=inserted.atID,aCode=inserted.aCode
from inserted
要一个字段一个字段的写。
想把表inserted的所有东西复制到asssetChange里面？
SELECT aID,atID,aCode,aSerise,aSpec,aProvider,aMainList,
aCDList,aBetteryList,aProTime,aNum,aDate,aRemark,aCPU,aDisk,aRam,State INTO assetChange FROM inserted
或
INSERT INTO assetChange SELECT * FROM inserted;