将列值作为属性添加到xml字段中

I would like to add an attribute value to an xml field in a query. my example is belowI would like to add an attribute value to an xm