修改和查询sqlserver里面的xml 好像只能一个个改不能批量
select [ExtendFieldId], [Setting].value('(/UploadFileViewModel/UploadProviderKey)[1]', 'nvarchar(max)') FROM [hj0523-8].[dbo].[ExtendField] where [Setting].value('(/UploadFileViewModel/UploadProviderKey)[1]', 'nvarchar(max)') = 'ContentManageContentExtendField' update [hj0523-8].[dbo].[ExtendField] set [Setting].modify('replace value of (/UploadFileViewModel/UploadProviderKey/text())[1] with "ContentExtendField"') where [ExtendFieldId]=67