2009 年 9月随笔档案 - D.Henry

远程SQL插入数据

摘要：insert opendatasource('sqloledb','data source=202.119.202.222;User ID=sa;Password=123').HB_K.dbo.safe_mubanbiao values (1,'33') 阅读全文

posted @ 2009-09-25 23:55 D.Henry 阅读(340) 评论(0) 推荐(0)

sql inner连接

摘要：SELECT SUM(DayFact) AS jituangongsi, SUM(CASE WHEN kuangid = 2 THEN DayFact ELSE 0 END) AS kuangchanliang, yueFROM (SELECT KM_KtjcDay.DayFact, AQ_ServerName.DiffDepartmentName AS kuangming, AQ_Ser... 阅读全文

posted @ 2009-09-25 23:00 D.Henry 阅读(273) 评论(0) 推荐(0)

sql sum 与 case 结合

摘要：SUM(CASE WHEN kuangid = 2 THEN DayFact ELSE 0 END) 阅读全文

posted @ 2009-09-25 22:50 D.Henry 阅读(413) 评论(0) 推荐(0)

加一天操作

摘要：当前日期加一天SQL:convert(nvarchar(10),dateadd(day,1,getdate()),120)C#：System.DateTime.Now.AddDays(1).ToString("yyyy" + "年" + "MM" + "月"+"dd"+"日"); 阅读全文

posted @ 2009-09-04 16:30 D.Henry 阅读(1535) 评论(0) 推荐(1)

SQL游标循环取值

摘要：declare @maxid intdeclare @zhibanren nvarchar(30)declare @shoujihao nvarchar(30)declare @banci nvarchar(5)declare @zhibanshijian datetimeselect @maxid=ID from safe_message_zhibanbiao where day(getdate... 阅读全文

posted @ 2009-09-03 19:58 D.Henry 阅读(2480) 评论(0) 推荐(1)