摘要:
DECLARE MyCursor CURSORFOR select Name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsView') = 1 and (not name in ('sysconstraints','syssegments')) DECLARE @name varchar(40)OPEN MyCursor FETCH NEXT FROM MyCursor INTO @nameWHILE (@@fetch_status <> -1)BEGIN IF (@@fetch_ 阅读全文
摘要:
10000->10,000///货币格式转换functionmakemoney(mm){varmoneyStr=mm.toString()||"";varnumArr=moneyStr.split('.');if(!numArr)return0; varre=/(-?\d+)(\d{3})/;varints=numArr[0];while(re.test(ints)){ints=ints.replace(re,"$1,$2");} varres=ints;if(numArr.length>1)res=ints+".& 阅读全文