正如Mikael所述，您需要描述更新背后的逻辑。但是对于上面的预期输出，以下应该起作用：
DECLARE @Words xmlSELECT @Words = '<word A="al" B="h" C="Ps" /><word A="has" B="es" C="Pf" /><word A="mom" B="es" C="Ph" />'SET @Words.modify('replace value of(/word[@A = "al"]/@B)[1] with "B1"')SET @Words.modify('replace value of(/word[@A = "al"]/@C)[1] with "C1"')SET @Words.modify('replace value of(/word[@A = "has"]/@B)[1] with "B2"')SET @Words.modify('replace value of(/word[@A = "has"]/@C)[1] with "C1"')SET @Words.modify('replace value of(/word[@A = "mom"]/@B)[1] with "B2"')SET @Words.modify('replace value of(/word[@A = "mom"]/@C)[1] with "C2"')SELECT @Words
