java璀璨小菜鸟

摘要： insert into Categorylink(id,objid,objtype,categoryid)values(REPLACE(CONVERT(NVARCHAR(36), NEWID()), '-', ''),'2c928e48980c74d9019878374514659a','Proje 阅读全文

摘要： select count(id) from workflowbase where isdelete=0 and id in(select workflowid from workflowlog where operator in('4028e5e55f6dfac3015f7be47a9f6efb', 阅读全文

摘要： CREATE OR REPLACEFUNCTION getSelectitemNameByIds( p_ids IN VARCHAR2) RETURN VARCHAR2IS v_selectitemid VARCHAR2(32); v_result VARCHAR2(4000) := ''; v_t 阅读全文

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