sqlserver 按精度和取整方式格式化数值
摘要: IFOBJECT_ID('dbo.Fun_fomrataccnum')ISNOTNULLDROPFUNCTIONdbo.Fun_fomrataccnumgoCREATEFUNCTIONdbo.Fun_fomrataccnum(@numNUMERIC(38,4),--数值@roundtypeint,--整方式类型1舍去零头2四舍五入3直接进位@precINT/*精度2-分1角0-元-1十元-2百-3千-4万*/)RETURNSNUMERIC(38,4)ASBEGINIF@roundtype=1SET@num=ROUND(@num,@prec,1)ELSEIF@roundtype=阅读全文
posted @ 2011-05-31 18:25 肥鱼 阅读(184) | 评论 (0) 编辑
