如何同时更新多个表? [英] How to update multiple tables at the same time?

问题描述

我正在尝试更新三个不同表中的字段，但出现一些错误:

I'm trying to update fields from three different tables but I'm getting some errors:

UPDATE 
  a, b, c
SET 
  a.Locked = 0, 
  b.Locked = 0, 
  c.Locked = 0, 
  a.LockedByUsername = 'zolomon', 
  b.LockedByUsername = 'zolomon', 
  c.LockedByUsername = 'zolomon', 
  a.LockedAt = CURRENT_TIMESTAMP, 
  b.LockedAt = CURRENT_TIMESTAMP, 
  c.LockedAt = CURRENT_TIMESTAMP
FROM 
  TableA AS a
  INNER JOIN TableB as b ON n.Objid = o.Objid
  INNER JOIN TableC as c ON n.Namnid = e.Namnid 
WHERE
  a.Namn1 = 'FirstName LastName' AND b.objektkod='SomeIdentifier'

和错误:

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ','.

推荐答案

您无法在单个 update 查询中更新多个表中的字段.您收到的错误是因为这是不允许的:

You can't update fields from multiple tables on a single update query. There error you are getting is because this is not permitted:

update a, b, c

因为每个 update 命令只能更新一个表.

Since you can only update one table per update command.

这篇关于如何同时更新多个表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！