数据库字段类型 XML字段的操作 数据库表名是 mengzhuDB 字段名：PropertyXml 11111 select PropertyXml.value('(/a/b/b1)[1]','int') from mengzhuDB where Id='唯一标识' declare @a int set @a = 22222 update mengzhuDB set PropertyXml.modify('replace value of (/a/b/b1/text())[1] with "'+@a+'"') where Id='唯一标识' 更新后的结果就是 22222 declare @sqltxt varchar(1000),@a int set @a=60 set @sqltxt ='update mengzhuDB set PropertyXml.modify(''replace value of (/a/b/b1/text())[1] with "'+CONVERT(varchar(10),@a)+'"'') where Id=''唯一标识''' 60 print @sqltxt exec (@sqltxt)
