Xquery增删改XML更新SQL语句UPDATE customer set info xmlquery(transform copy $mycust:$custmodifyd
Xquery增删改
XML更新
SQL语句
UPDATE customer set info = xmlquery('transform copy $mycust:=$custmodifydo delete ($mycust/customerinfo/phone[@type="home"]) return $mycust' passing info as "cust")WHERE CID = 1000注意:''中的大小写。