select cast(12.347343 as decimal(18,2)) 12.35 转载于:https://www.cnblogs.com/zgaspnet/archive/2011/11/17/2252772.html