.net
文章平均质量分 77
zhanghongqiao
简单最好
展开
-
C#颜色和名称对照表
Color.AliceBlue240,248,255Color.LightSalmon255,160,122Color.AntiqueWhite250,235,215Color.LightSeaGreen32,178,170Color.Aqua0,255,255C转载 2012-02-03 14:49:57 · 916 阅读 · 0 评论 -
身份证提取生日,判断性别
/// /// 验证身份证号码 /// /// /// public static bool CheckIDCard(string Id) { if (Id.Length == 18) { bool原创 2012-02-17 14:41:27 · 2406 阅读 · 0 评论 -
五大数据库常用SQL比较(一)
一、连接列值db2/oracle/postgresqlselect name(字段)||' Works AS a '(文字)||job as msg from emp where deptno=10;mysqlselect concat(name,' works as a',job) as msg from emp where deptno=10;sql server转载 2012-06-05 15:40:18 · 734 阅读 · 0 评论 -
五大数据库常用SQL比较(四)
七十三、显示一年中的每季度的第一天和最后一天db2select quarter(dy-1 day) QTR,day-3 month Q_start,dy-1 day Q_end from (select (current_date-(dayofyear(current_date)-1) day +(rn*3) month) dy from (select row_number() ov转载 2012-06-05 16:10:48 · 875 阅读 · 0 评论 -
五大数据库常用SQL比较(五)
九十一、转换列值db2/sqlserver/mysql/postgresqlselect e.ename, e.sal,coalesce((select min(sal) from emp d where d.sal > e.sal),(select min (sal) from emp) ) as forward,coalesce((select max(sal) from em转载 2012-06-05 16:11:10 · 761 阅读 · 0 评论 -
五大数据库常用SQL比较(二)
二十四、用其他表中的值更新db2/mysqlupdate emp e set(e.sal,e.comm)=(select ns.sal,ns.sal/2 from new_sal ns where ns.deptno=e.deptno) where exists(select nul from new_sa ns where ns.deptno=e.deptno)oracleu转载 2012-06-05 16:02:32 · 838 阅读 · 1 评论 -
五大数据库常用SQL比较(三)
四十九、生成累计和db2/oracleselect ename,sal,sum(sal) over (order by sal,empno) as running_total from emp order by 2mysql/postgresql/sqlserverselect e.ename,e.sal,(select sum(d.sal) from emp d where转载 2012-06-05 16:10:20 · 904 阅读 · 0 评论 -
五大数据库常用SQL比较(六)
一〇六、返回非组列db2/oracle/sqlserverselect deptno,ename,job,sal,case when sal = max_by_dept then 'TOP SAL IN DEPT' when sal = min_by_dept then 'LOW SAL IN DEPT' end dept_status,case when sal = max_by转载 2012-06-05 16:11:37 · 824 阅读 · 0 评论