MS SQL Server numeric capacities can be applied on numeric information and will restore numeric information.
Following is the rundown of Numeric capacities with models.
ABS()
Supreme worth will come as yield for numeric articulation.
Example
The accompanying question will give the outright worth.
Select ABS(-22)
ACOS()
Circular segment cosine worth will come as yield for the predetermined numeric articulation.
Example
The accompanying question will give the bend cosine estimation of 0.
Select ACOS(0)
ASIN()
Circular segment sine worth will come as yield for the predetermined numeric articulation.
Example
The accompanying question will give the curve sine estimation of 0.
Select ASIN(0)
ATAN()
Bend digression worth will come as yield for the predefined numeric articulation.
Example
The accompanying inquiry will give the bend digression estimation of 0.
Select ATAN(0)
ATN2()
Bend digression esteem in every one of the four quadrants will come as yield for the predefined numeric articulation.
Example
The accompanying question will give the circular segment digression esteem in every one of the four quadrants of 0.
Select ATN2(0, -1)
Consider the CUSTOMERS table having the accompanying records.
ID NAME AGE ADDRESS SALARY
1 Ramesh 32 Ahmedabad 2000.00
2 Khilan 25 Delhi 1500.00
3 kaushik 23 Kota 2000.00
4 Chaitali 25 Mumbai 6500.00
5 Hardik 27 Bhopal 8500.00
6 Komal 22 MP 4500.00
7 Muffy 24 Indore 10000.00
BETWEEN()
On the off chance that the qualities exist between given two articulations, at that point those will be come as yield.
Example
The accompanying question will give the accompanying yield.
SELECT salary from customers where salary between 2000 and 8500
Yield
salary
2000.00
2000.00
6500.00
8500.00
4500.00
MIN()
Least worth will come as yield from the given articulation.
Example
The accompanying question will give '1500.00' for the given 'compensation' articulation from the clients table.
Select MIN(salary)from CUSTOMERS
MAX()
Greatest worth will come as yield from the given articulation.
Example
The accompanying question will give '10000.00' for the given 'compensation' articulation from the clients table.
Select MAX(salary)from CUSTOMERS
SQRT()
Square foundation of the given numeric articulation will come as yield.
Example
The accompanying question will give 2 for the given 4 numeric articulation.
Select SQRT(4)
PI()
PI worth will come as yield.
Example
The accompanying question will give 3.14159265358979 for the PI esteem.
Select PI()
CEILING()
Given worth will come as yield in the wake of adjusting the decimals which is the following most elevated worth.
Example
The accompanying question will give 124 for the given 123.25 worth.
Select CEILING(123.25)
FLOOR()
Given worth will come as yield subsequent to adjusting the decimals which is not exactly or equivalent to the articulation.
Example
The accompanying question will give 123 for the given 123.25 worth.
Select FLOOR(123.25)
LOG()
Normal logarithm of the given articulation will come as yield.
Example
The accompanying question will give 0 for the given 1 worth.
Select LOG(1)