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
