lijian260的专栏

原创 sql 让合计行永远在最后一行

Select   Name,convert(char(10),Gz,4)   as   Gz   from   T_Gz     union   all   Select   '合计工资 ',convert(char(13),sum(Gz),4)   from   T_Gz   order   by   case   when   Name= '合计工资 '   then   1

转载 JS判断一个数组中是否有重复值的三种方法

方法一:var ary = new Array("111","22","33","111");var s = ary.join(",")+","; for(var i=0;iif(s.replace(ary[i]+",","").indexOf(ary[i]+",")>-1) {alert("数组中有重复元素：" + ary[i]);break;}}方法二:

原创 sql 取最大的id 的内容

SELECT *  FROM dbo.Ys_CloseOPen AS a INNER JOIN             dbo.Ysmx_CloseOpen AS b ON a.TaskID = b.TaskIDwhere  a.iyear = '2012' and a.imonth = '2' and a.taskid = (select max(TaskID) from dbo.Y

原创 我的第一个abap程序 helloword！