摘要: select * into zhkc from lskc 复制表so easy。备份单个表很实用sqldel = "delete from zhkc where FA not in(select min(FA) from zhkc group by A0)";可以删除重复记录,稍加变换可以作用无穷,比如根据时间戳就行增量下载后,删除原来的库存数据。 阅读全文
posted @ 2010-12-14 18:16 神一样的疯子 阅读(328) 评论(0) 推荐(0)
摘要: using System;using System.IO;using System.Windows.Forms;using System.Collections;using System.Xml;using System.Runtime.InteropServices; //**********************************************************************//** Create By: 熊鹰//** Create Date: 2006-07-20//** Description: 操作本地用户和组的类//** Modify List:/ 阅读全文
posted @ 2010-12-14 18:13 神一样的疯子 阅读(1084) 评论(0) 推荐(0)
摘要: DateTime dt = DateTime.Now; //当前时间DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一DateTime endWeek = startWeek.AddDays(6); //本周周日DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末//DateTime endMo 阅读全文
posted @ 2010-12-14 18:10 神一样的疯子 阅读(2401) 评论(0) 推荐(1)