摘要：
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 阅读全文
