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注意:''中的大小写。
发布时间： 2012-07-04 19:33:55 作者： rapoo
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