tsql - 如何同时更新多个表？

Question

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

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 ','.

Answer 1

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

update a, b, c

由于您只能通过 update命令更新 一个表。