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

如果需要选择数据，则可以使用xquery：

select    t.xmlCol.query('         element book {  for $i in book/@* return $i,  attribute quantity {sql:column("t1.quantity")},  for $i in book/* return $i         }    ')from @table t    inner join @table1 t1 on t.bookid = t1.bookid

[sql fiddle demo](http://sqlfiddle.com/#!3/d41d8/21875)

甚至更简单：

select    t.xmlCol.query('         element book {  book/@*,  attribute quantity {sql:column("t1.quantity")},  book/*         }    ')from @table t    inner join @table1 t1 on t.bookid = t1.bookid

[sql fiddle demo](http://sqlfiddle.com/#!3/d41d8/21883)