SQLServer常用函数对比.doc

SQLServer和Oracle的常用函数对比1.绝对值 S:select abs(-1) valueO:select abs(-1) value from dual2.取整(大) S:select ceiling(-1.001) value O:select ceil(-1.001) value from dual3.取整（小） S:select floor(-1.001) value O:select floor(-1.001) value from dual4.取整（截取）S:select cast(-1.002 as int) value O:select trunc(-1.002) value from dual 5.四舍五入S:select round(1.23456,4) value 1.23460O:select round(1.23456,4) value from dual 1.23466.e为底的幂 S