摘要：with temp as(select *From tb_order where Auditing=2 and AuditingTime>='2013-04-01' and Flag=2)select *from temp where EbayAccountID=21 相当于临时表 temp 分析器可以智能提示 临时表却不能。临时表select * into #temp From tb_order where Auditing=2 and AuditingTime>='2013-04-01' and Flag=2select * From #temp 阅读全文

摘要：a. 一个月的第一天SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)b. 本周的星期一SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)c. 一年的第一天SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)d. 季度的第一天SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)e. 上个月的最后一天SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))f. 阅读全文

摘要：有时我们知道了两个DataTable1和DataTable2，我们希望将它们合并为一个新的DataTable（下面的例子中命名为了newDataTable），这就分为两种情况：DataTable1和DataTable2结构相同、DataTable1和DataTable2结构不同，下面分别介绍怎么进行合并。一、DataTable1和DataTable2结构相同的情况，结构相同我们只需要把两者的数据罗列到一块就可以了首先初始化相同结构DataTable（测试用的） void InitDataTable1(DataTable dt) { dt.Columns... 阅读全文

摘要：private static ArrayList DataTableToArrayList(DataTable dt){ArrayList array = new ArrayList();for (int i = 0; i < dt.Rows.Count; i++){DataRow row = dt.Rows[i];Hashtable Ht= new Hashtable();for (int j = 0; j < dt.Columns.Count; j++){object cellValue = row[j];if (cellValue.GetType() == typeof(DB 阅读全文

摘要：SELECT 网站名称, 姓名 ,SUM(产品数)as 产品数from(SELECT f.Url as 网站名称, e.Name AS 姓名,a.OrderNumber ,SUM(b.Quality)as 产品数FROM tb_order(nolock) as aleft join tb_OrderList as b on b.OrderID=a.IDleft join tb_WebSitePromotion as c on c.WebSiteInfoID=a.WebSiteInfoID and c.SpreadTypeID=2 and c.StartDate0 and len(isnull( 阅读全文

摘要：SELECT *FROM tb_User ORDER BY ID DescOFFSET 1000 ROWSFETCH NEXT 20 ROWS ONLY; 阅读全文

摘要：第一种方法：select *from ( select Url,case when Month=01 then '1月' when Month=02 then '2月' when Month=03 then '3月' when Month=04 then '4月' when Month=05 then '5月' when Month=06 then '6月' when Month=07 then '7月' when Month=08 then '8月' when Mo 阅读全文

摘要：DataTable dt = new DataTable(); System.Data.DataTable ExcelTable; DataSet dst = new DataSet(); string strconn = ""; if (this.currFileExtension==".xls")//这样判断不太好 暂时未找出判断Excel版本的解决办法 { strconn = "... 阅读全文