var str='get-element-by-id'; function strToupper(str) { //利用split将字符串分割成数组var arr= str.split('-'); for (var i = 1; i<arr.length; i++) { //1.利用for循环获取数组的每个元素,2.用charAt(0)获取每个元素的第一个字符:3.用substr方法获取除第一个字符以外的其它字符并拼接: arr[i]=arr[i].charAt(0).toUpperCase()
select U.CnName+',' from f_splitstr('1828,1055333,1,1035681,752,494,22549,219,23860,478,23453,677,718,782,2358', ',') join T_BD_User U on U.ID=F1 for xML PATH('') select RoleName,ExecutorName, case when temp.CnName='' then '' when temp.CnNa