摘要: with temp ( [Id], [parentid]) as ( select Id, parentid from DiGui where [parentid] = 15 union all select a.Id, a.parentid from DiGui a inner join temp 阅读全文
posted @ 2017-07-25 15:54 wuyong360 阅读(103) 评论(0) 推荐(0) 编辑
摘要: LINQPad4.zip linq转sql文件 一:where 嵌套查询 var q=from p in db.ParkingSpace join uw in db.sys_user_web on p.yardNumber equals uw.yardNumber where (from u in 阅读全文
posted @ 2017-07-25 15:39 wuyong360 阅读(154) 评论(0) 推荐(0) 编辑