【正文】 if(pare(current, \u531d) = 0) pare(current, \u5ea7) = 0) {string current = (i, i + 1)。 for(int i = 0。 { public static string getbegincharacter(string res) }int s2_code = getcharcode((i) + )。 i n。 int n = (len1, len2)。 { public static int chinesepareto(string s1, string s2) } i++)value = value * 100 + b[i]。 for(int i = 0。 catch(exception e) try return v_result。 增加一個(gè)元素 v_result() := gzType(i,t)。 v_result gzTableType:=gzTableType()。)。,39。,39。,39。,39。,39。 dz myDz:=myDz(39。壬39。庚39。戊39。丙39。甲39。end。 調(diào)整地支索引 end loop。begin for i in 1 .. 60 loop t:=tg(indexTg+1) || dz(indexDz+1)。)。,39。,39。,39。,39。,39。 dz myDz:=myDz(39。壬39。庚39。戊39。丙39。甲39。 20100228 二零一零年|一月|十五 正月十五(元宵節(jié)) 陰歷返回結(jié)果：陽歷 else right(cast((day(OUTPUTDATE) )as varchar(4)),1)end else 39。+ case when right(cast((day(OUTPUTDATE) )as varchar(4)),1)=39。 then left(cast((day(OUTPUTDATE) )as varchar(4)),1) else 39。then 39。 else right((month(OUTPUTDATE)),1) end else cast((month(OUTPUTDATE)) as varchar(4)) end +39。+ case when right((month(OUTPUTDATE)),1)=39。 then left(month(OUTPUTDATE),1) else 39。+CAST(DAY AS VARCHAR(2))) AS DATETIME) ,120) select convert( varchar(10),solarDay ,120) as 陽歷 ,cast((year(OUTPUTDATE)) as varchar(8))+39。 temp 0 SET mDays = 30 ELSE SET mDays = 29 END 解除閏月 IF bLeap=1 AND i= (mLeap+1) SET bLeap=0 SET offset=offsetmDays SET i=i+1 END IF offset = 0 BEGIN SET offset=offset+mDays SET i=i1 END 確定農(nóng)歷月結(jié)束 SET MONTH=i 確定農(nóng)歷日結(jié)束 SET DAY=offset SET OUTPUTDATE=convert(varchar(10),CAST((CAST(YEAR AS VARCHAR(4))+39。 15 傳回農(nóng)歷年閏月的天數(shù),加在年的總天數(shù)上 IF mLeap 0 BEGIN IF iLunar amp。,CAST(SUBSTRING(n_str,i,1) AS int)+1,1) SET i=i+1 END RETURN reEND. 根據(jù)陽歷返回對(duì)應(yīng)的陰歷CREATE PROCEDURE GetLunar_zhangzs solarDay DATETIME 日期AS DECLARE solData int DECLARE offset int DECLARE iLunar int DECLARE i INT DECLARE j INT DECLARE yDays int DECLARE mDays int DECLARE mLeap int DECLARE mLeapNum int DECLARE bLeap smallint DECLARE temp int DECLARE YEAR INT DECLARE MONTH INT DECLARE DAY INT DECLARE OUTPUTDATE varchar(10) 保證傳進(jìn)來的日期是不帶時(shí)間 SET solarDay=cast(solarDay AS char(10)) SET offset=CAST(solarDay39。,44448：CREATE FUNCTION [dbo].[f_num_str] (num int)RETURNS varchar(100)ASBEGIN DECLARE n_str VARCHAR(20),re VARCHAR(20),i int SELECT n_str=cast(num as varchar),i=1,re=39。,111189UNION ALL SELECT 2048,39。,42160UNION ALL SELECT 2046,39。,18864UNION ALL SELECT 2044,39。,22224UNION ALL SELECT 2042,39。,56645UNION ALL SELECT 2040,39。,53840UNION ALL SELECT 2038,39。,42192UNION ALL SELECT 2036,39。,19415UNION ALL SELECT 2034,39。,30371UNION ALL SELECT 2032,39。,54576UNION ALL SELECT 2030,39。,53856UNION ALL SELECT 2028,39。,42726UNION ALL SELECT 2026,39。,23378UNION ALL SELECT 2024,39。,27296UNION ALL SELECT 2022,39。,43312UNION ALL SELECT 2020,39。,86390UNION ALL SELECT 2018,39。,19360UNION ALL SELECT 2016,39。,44368UNION ALL SELECT 2014,39。,46240UNION ALL SELECT 2012,39。,51893UNION ALL SELECT 2010,39。,9680UNION ALL SELECT 2008,39。,22176UNION ALL SELECT 2006,39。,55888UNION ALL SELECT 2004,39。,55636UNION ALL SELECT 2002,39。,37600UNION ALL SELECT 2000,39。,43872UNION ALL SELECT 1998,39。,27480UNION ALL SELECT 1996,39。,29859UNION ALL SELECT 1994,39。,18800UNION ALL SELECT 1992,39。,38256UNION ALL SELECT 1990,39。,44870UNION ALL SELECT 1988,39。,27216UNION ALL SELECT 1986,39。,42160UNION ALL SELECT 1984,39。,18864UNION ALL SELECT 1982,39。,103846UNION ALL SELECT 1980,39。,46400UNION ALL SELECT 1978,39。,53840UNION ALL SELECT 1976,39。,42192UNION ALL SELECT 1974,39。,19925UNION ALL SELECT 1972,39。,22176UNION ALL SELECT 1970,39。,55632UNION ALL SELECT 1968,39。,21088UNION ALL SELECT 1966,39。,43748UNION ALL SELECT 1964,39。,43856UNION ALL SELECT 1962,39。,27296UNION ALL SELECT 1960,39。,43432UNION ALL SELECT 1958,39。,83315UNION ALL SELECT 1956,39。,19872UNION ALL SELECT 1954,39。,46416UNION ALL SELECT 1952,39。,46423UNION ALL SELECT 1950,39。,53938UNION ALL SELECT 1948,39。,9680UNION ALL SELECT 1946,39。,22176UNION ALL SELECT 1944,39。,120998UNION ALL SELECT 1942,39。,51536UNION ALL SELECT 1940,39。,37600UNION ALL SELECT 1938,39。,11104UNION ALL SELECT 1936,39。,28309UNION ALL SELECT 1934,39。,54432UNION ALL SELECT 1932,39。,18800UNION ALL SELECT 1930,39。,38256UNION ALL SELECT 1928,39。,109396UNION ALL SELECT 1926,39。,27216UNION ALL SELECT 1924,39。,42160UNION ALL SELECT 1922,39。,84343UNION ALL SELECT 1920,39。,44450UNION ALL SELECT 1918,39。,46400UNION ALL SELECT 1916,39。,53840UNION ALL SELECT 1914,39。,42422UNION ALL SELECT 1912,39。,21970UNION ALL SELECT 1910,39。,22176UNION ALL SELECT 1908,39。,55632UNION ALL SELECT 1906,39。,21717UNION ALL SELECT 1904,39。,19168UNION ALL SELECT 1902,39。 dataInt int not null)INSERT INTO SolarData SELECT 1900,39。注意：一組數(shù)可能沒有眾數(shù)！此時(shí)CTE將返回空集！查詢出連續(xù)的記錄有一個(gè)表結(jié)構(gòu)，fphm,kshm,其記錄如下：2014,000000012014,000000022014,000000032014,000000042014,000000052014,000000072014,000000082014,000000092013,000001202013,000001212013,000001222013,000001242013,00000125(第二個(gè)字段內(nèi)可能是連續(xù)的數(shù)據(jù)，可能存在斷點(diǎn)。子句WITHIN GROUP (ORDER BY SAL)確定PERCENTILE_CONT要搜索哪些有序行（記住，中間值就是一組已排序值的中間值）。 ）。，TOTAL和halfT，還用到由ROW_NUMBER生成的RN。insert into empInfo values(39。,2500)。李薇霞39。insert into empInfo values(39。,800)。在SELECT列表中加入SUM就可以觀察到這種情況：select avg(sal) from ( 找到中間位置的sal值 select ,count() ncount, sum(case when = then 1 else 0 end) sum0, abs(sum(sign( )) ) abs0 from empInfo e, empInfo d group by having sum( case when = then 1 else 0 end )= abs(sum(sign( )))end abs )t800 7 1 61100 7 1 41500 7 1 22200 7 1