随笔分类 - 常用方法
日常用到的一些方法
摘要：CAST(extnumfield0 AS VARCHAR(50))
阅读全文
摘要：select stuff((select ','+objname from contract where charindex(id,pactid) > 0 for xml path('')),1,1,'') from project where id='2c928b7992f766440192fc2
阅读全文
摘要：select GROUP_CONCAT(CONCAT(objname,'-',id)) from humres
阅读全文
摘要：SELECT * FROM `sign_rule` WHERE ( `start_time` > $startTime AND `start_time` < $endTime ) OR ( `start_time` <= $startTime AND `end_time` >= $endTime )
阅读全文
摘要：SELECT * INTO NewTable FROM OriginalTable;
阅读全文
摘要：1.String projectids=""; 2. if (StringHelper.isNotEmpty(gatheringinfo.getCol1()) && gatheringinfo.getCol1().length()>0){ projectids+=gatheringinfo.getC
阅读全文
摘要：SELECT STUFF( (SELECT ',' + id FROM assets where id in('4028e481467e27a4014683c552db1794','4028e481467e27a4014683c6ff7717d4') FOR XML PATH('')), 1, 1,
阅读全文
摘要：1.这种是后面有逗号的select xmlagg(xmlparse(content files || ','wellformed) order by files).getclobval() as files from (select field008 as files from ufp2h3p816
阅读全文
摘要：问题 解决方法 点击事件需要重新加载一下iframe
阅读全文
摘要：1.原本图 2.解决方法 select regexp_substr(a.numbers,'[^,]+',1,level) as numbers from (select distinct id,numbers from project where isdelete=0 and isactive=1
阅读全文
摘要：--（1）2021年至今天为止签订的合同（不含付款合同）里面，一共有多少个客户（相同的客户要合并算作一个）；1171--（2）2021年至今天为止签订的合同（不含付款合同）里面，帮我统计一个清单，就是累计合同签订额最高的15个客户。 --1,合同金额不为0select (select objname
阅读全文
摘要：select exttextfield6 from assets where charindex(id,'8a070cd88ab2a995018ad0c69def060a,8a070cd88ab2a995018ad0c69ffb0625') > 0 实例：select stuff((select '
阅读全文
摘要：1.select stuff((select ','+a.exttextfield1 from project a where ','+ b.field027 +',' like '%,'+cast(a.id as varchar(32))+',%' for xml path('') ),1,1,'
阅读全文
摘要：select * from docbase where isdelete=0update docbase set subject=STUFF(subject,23,4,'****') where isdelete=0 update docbase set subject=STUFF(subject,
阅读全文
摘要：update formlayoutfield set formula='''$currentuser$''=field001 or ((select orgid from humres where id=''$currentuser$'')=''402880ec5c99d3bd015c9a17bba
阅读全文
摘要：1.通过一个中间的jsp进行json查询传递 <%@ page import="java.util.Map" %> <%@ page import="java.util.ArrayList" %> <%@ page import="java.util.List" %> <%@ page import
阅读全文
摘要：select RAWTOHEX(sys_guid()) from dual
阅读全文
摘要：可以使用 Set 集合来去重，然后再将集合中的元素转换为字符串。 String str = "a,b,c,c,d,e,e,f"; String[] arr = str.split(","); Set<String> set = new HashSet<String>(Arrays.asList(ar
阅读全文
