2021年 数学函数整理MSSQL SERVER

1、time is just passing by, and you are the master. the road of life does not need to be exacting. as long as you take a step, the road will extend under your feet. as long as you set sail, there will be wind from all directions. once you set off, your life will truly begin.通用参考模板（页眉可删）2021年 数学函数整理mssq

2、l server mssql server _ 数学函数1.求绝对值abs()select fweight-50,abs(fweight-50),abs(-5.38) from t_person2.求幂power(x,y) 用来计算x的y次幂select fweight,power(fweight,-0.5),power(fweight,2),power(fweight,3),power(fweight,4) from t_personselect power(2,2)3.求平方根sqrt()select fweight,sqrt(fweight) from t_person4. 求随机数ra

3、nd() 支持有参数，也可以没参数select rand()select rand(123)5.舍入到最大整数ceiling()select fname,fweight,ceiling(fweight),ceiling(fweight_-1) from t_person6.舍入到最小整数floor()select fname,fweight,floor(fweight),floor(fweight_-1) from t_person7.四舍五入round()round(m,d) m为待进行四舍五入的数值，d为计算精度，也就是四舍五入时保留的小数位数d为0表示不保留小数位，d为负值表示在整数部分

4、进行四舍五入。select fname,fweight,round(fweight,1),round(fweight_-1,0),round(fweight,-1) from t_person8.求正弦值sin()select fname,fweight,sin(fweight)from t_person9.求余弦值cos()select fname,fweight,cos(fweight) from t_person10.求反正弦asin()select fname,fweight,asin(1/fweight) from t_person11.求反余弦acos()select fname,

5、fweight,acos(1/fweight) from t_person12.求正切值tan()select fname,fweight,tan(fweight) from t_person13.求反正切值atan()select fname,fweight,atan(fweight) from t_person14.求两个变量的反正切atn2(x,y) 类似于计算y/x的反正切select fname,fweight,atn2(fweight,2) from t_person15.求余切cot()select fname,fweight,cot(fweight) from t_person

6、16.求圆周率值pi()select fname,fweight,fweight_pi(),pi() from t_person17.弧度制转换为角度制degrees() 结果的精确度与参数有关select degrees(pi(),degrees(3.0),degrees(3)18.角度制转换为弧度制radians() 结果的精确度与参数有关select radians(180),radians(180.0)19.求符号sign() 返回一个数值的符号，如果数值大于0则返回1，如果数值等于0则返回0，如果数值小于0则返回-1.结果的精确度与参数有关select fname,fweight-4

7、8.68,sign(fweight-48.68),sign(1),sign(1.000) from t_person20.求整除余数 %select fname,fweight,fweight%5 from t_person21.求自然对数log()select fname,fweight,log(fweight),log(1.00) from t_person22.求以10为底的对数log10()select fname,fweight,log10(fweight),log10(100) from t_personps：主要参照程序员的sql金典实例有所改动。t_person表的创建复制代码 代码如下:c