摘要: --SQL函数******************************--数学函数...--abs 返回数值的绝对值:select *from SC where sno = '3130050106' update SC set score = abs(-90) where sno = '3130050106'--ROUND函数select round(12345.34567,3) --精确到小数点后,12345.34600selectround(12345.34567,-3)--精确到小数点前,12000.00000go--字符串函数...--substri 阅读全文
posted @ 2011-08-19 10:35 jdsbj170 阅读(133) 评论(0) 推荐(0) 编辑