sql-server - 更新 Transact SQL 链接表时影响了太多行错误

Question

我正在尝试使用此更新链接表...

update openquery (LINKSERVERID, 'select tng_email from user_list where tng_id = 62873') 
  set tng_email = 'blah@blah.com';

...但我收到以下错误...

OLE DB provider "MSDASQL" for linked server "LINKSERVERID" returned message "Key column information is insufficient or incorrect. Too many rows were affected by update.".

仅供引用:tng_id 是主键。

我该如何解决？

Answer 1

我认为您需要在选择查询中包含键，所以试试这个:

update openquery(
  LINKSERVERID, 'select tng_id, tng_email from user_list where tng_id = 62873'
) set tng_email = 'blah@blah.com';