尝试像这样更新。
UPDATe ASET title = b.title, summary = b.summary, post = b.post, departmentID = b.departmentIDFROM RC_Posts A JOIN (SELECt title=[Xml_Tab].[Cols].value('(title)[1]', 'nvarchar(100)'), summary=[Xml_Tab].[Cols].value('(summary)[1]', 'nvarchar(500)'), post=[Xml_Tab].[Cols].value('(post)[1]', 'nvarchar(max)'), departmentID=[Xml_Tab].[Cols].value('(departmentID)[1]', 'int'), PostID=[Xml_Tab].[Cols].value('(postID)[1]', 'int') FROM @xmlMain.nodes('/root') AS [Xml_Tab]([Cols])) B ON a.postID = b.postID
