摘要:
public static T DeepClone<T>(T obj) { using (var ms = new MemoryStream()) { var formatter = new BinaryFormatter(); formatter.Serialize(ms, obj); ms.Position = 0; return (T) formatter.Deserialize(ms); 阅读全文
摘要:
例: rank() over(partition by deptno order by sal desc) rank 解释: deptno -- 部门, sal -- 工资 over: 在什么条件之上。partition by e.deptno: 按部门编号划分(分区)。order by e.sal 阅读全文