修改和查询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

 

转载于:https://www.cnblogs.com/maijin/p/6902264.html