摘要: sql Bom 递归查询: with t as(select * from Department where id=6union allselect a.* from Department a,t where a.ParentId=t.id)select * from t 阅读全文
posted @ 2016-08-29 14:21 华琪 阅读(613) 评论(1) 推荐(0) 编辑
摘要: 数据库中存在字段类型为xml 的数据, 现举例 xml 字段存储的数据为: <MortgageInfoShipList> <ITEMS> <ITEM> <ShipName>船名2</ShipName> <Location>处所2</Location> <RegisterLocation>船籍港2</ 阅读全文
posted @ 2016-08-29 13:53 华琪 阅读(1636) 评论(0) 推荐(0) 编辑