摘要：
1 delete from TAB_JXGD_BPBJ a2 where not EXISTS (select jxdid from tab_jxgd b where a.jxgdid=b.jxdid) 阅读全文
摘要：
可以加两个日期之间任何一个时间单位。private string DateDiff(DateTime DateTime1, DateTime DateTime2) {string dateDiff = null; TimeSpan ts = DateTime1.Subtract(DateTime2).Duration(); dateDiff = ts.Days.ToString()+"天"+ ts.Hours.ToString()+"小时"+ ts.Minutes.ToString()+"分钟"+ ts.Seconds.ToStrin 阅读全文