摘要:
--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 阅读全文