05 2011 档案

摘要：//设置金额为两位小数function setAmount(obj) { var amount = $(obj).val() * 1.0; amount = amount.toFixed(2); if (isNaN(amount)) { amount = "0.00"; } $(obj).val(amount);} 阅读全文

摘要：--以天为单位 select count( *) as customercount,str(DATEPART(YY,RegTime)) + N'年' + cast( DATEPART(mm,RegTime) as varchar(5) )+ N'月' + cast( DATEPART(dd,RegTime) as varchar(5) )+ N'日' as timetypeFROM CRM_Customer WHERE 1=1GROUP BY DATEPART(YY,RegTime),DATEPART(mm,RegTime),DATEPART(d 阅读全文