摘要：表结构：People表,PeopleDetail表1.简单游标declare m_cursor cursor scroll for select Address,PeopleId from PeopleDetailopen m_cursordeclare @Address varchar(5... 阅读全文

摘要：统计中常用的日期函数：select @StatDate=DATEADD(dd,DATEDIFF(dd,0,getdate()),0)--今天凌晨select dateadd(dd,-1,@StatDate)--昨天凌晨DATEADD(mm,DATEDIFF(mm,0,getdate())-1,0)--上月的第一天DATEADD(mm,DATEDIFF(mm,0,getdate()),0)--本月的第一天if(DatePart(w,getdate())=1)--当前是星期天begin select DATEADD(wk,DATEDIFF(wk,0,getdate())-2,0)--上上周的第一天 阅读全文

摘要：--获取当前及以下部门Create proc GetCurrentAndUnderOrg@orgId intasbegin WITH cte AS ( SELECT * ,0 AS level FROM Static_Organ WHERE OrganID=@orgId UNION ALL SELECT g.*,level+1 FROM Static_Organ g INNER JOIN cte ON g.ParentOrgan=cte.OrganID ) SELECT * FROM cteend编辑器加载中... 阅读全文

摘要：1.表结构 2.查询语句create procedure Pro_GetUnderOrg(in idd varchar(36))begindeclare lev int;set lev=1;drop table if exists tmp1; CREATE TABLE tmp1(ID VARCHAR(36),OrgName varchar(50),ParentID varchar(36) ,levv INT); INSERT tmp1 SELECT ID,OrgName,ParentID,1 FROM `organization` WHERE ParentID=idd;while row_co 阅读全文

摘要：BULK INSERT dbo.tabTimeDataFROM 'F:\自动观测站\tabtimedata\tabtimedata.txt'WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n') 阅读全文

摘要：1,设置mySql连接字符串gb23122,PowerDesinger->Database->Generate Database->Format 阅读全文

摘要：View Code delete from StationInfo where StationID in (select StationID from StationInfo group by StationID having COUNT(StationID)>1) 阅读全文

摘要：Oracle不像SQL那样用的是“+”号，而是用“||”来合并的。即select a||b as c from tableSELECT REGIONID, '('||REGIONCHARID||') '|| REGIONNAME as c FROM SYS_REGION结果： 阅读全文

摘要：NVL(Expr1,Expr2)如果Expr1为NULL，返回Expr2的值，否则返回Expr1的值NVL2(Expr1,Expr2,Expr3)如果Expr1为NULL，返回Expr2的值，否则返回Expr3的值NULLIF(Expr1,Expr2)如果Expr1和Expr2的值相等，返回NULL，否则返回Expr1的值 阅读全文

摘要：SELECT COUNT(SOURCE_ID) FROM CNFG_RESOURCE_SCHEDULE WHERE SOURCE_ID='{0}' UNION ALL SELECT COUNT(SOURCE_ID) FROM DATA_FILES WHERE SOURCE_ID='{0}‘ 阅读全文