08 2012 档案

摘要：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Xml.Linq;using System.IO;namespace MySkinDemo{ public partial class Form1 : Form { public Form1() ... 阅读全文

摘要：1.Oracle递归查询2.SqlServer递归查询 with cte as ( select t.id,t.name,t.parentId from dbo.Department t where t.id='2' union all select k.id,k.name,k.parentId from dbo.Department k inner join cte c on c.id = k.parentId )select * from cte 阅读全文