常用SQL备忘

保留两位小数sql server:select **Convert**(decimal(18,2),2.176544) 结果:2.18select CAST(2.176544 as decimal(18,2))结果:2.18select Round(2.176544,2)  结果:2.180000