- Tags: SQL Server
- Categories: Reference, SQL Reference, SQL Resources
Quick Reference
This is a quick reference list of SQL Server numeric functions and how they are used to work with databases.
SQL – SQL Server ABS() Function
The SQL Server ABS() function returns the absolute value of a number.
SQL – SQL Server ACOS() Function
The SQL Server ACOS() function returns the arc cosine of a specified number between -1 and 1.
SQL – SQL Server ASIN() Function
The SQL Server ASIN() function returns the arc sine of a specified number between -1 and 1.
SQL – SQL Server ATAN() Function
The SQL Server ATAN() function returns the arc tangent of a number.
SQL – SQL Server ATN2() Function
The SQL Server ATN2() function returns the arc tangent of two numbers.
SQL – SQL Server AVG() Function
The SQL Server AVG() function returns the average value of an expression (NULL values are ignored).
SQL – SQL Server CEILING() Function
The SQL Server CEILING() function returns the smallest integer value that is larger than or equal to a number.
SQL – SQL Server COS() Function
The SQL Server COS() function returns the cosine of a number.
SQL – SQL Server COT() Function
The SQL Server COT() function returns the cotangent of a number.
SQL – SQL Server COUNT() Function
The SQL Server COUNT() function returns the number of records returned by a select query. NULL values are not counted.
SQL – SQL Server DEGREES() Function
The SQL Server DEGREES() function converts a value in radians to degrees.
SQL – SQL Server EXP() Function
The SQL Server EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.
SQL – SQL Server FLOOR() Function
The SQL Server FLOOR() function returns the largest integer value that is smaller than or equal to a number.
SQL – SQL Server LOG() Function
The SQL Server LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
SQL – SQL Server LOG10() Function
The SQL Server LOG10() function returns the natural logarithm of a number greater than 0 to base 10.
SQL – SQL Server MAX() Function
The SQL Server MAX() function returns the maximum value in a set of values.
SQL – SQL Server MIN() Function
The SQL Server MIN() function returns the minimum value in a set of values.
SQL – SQL Server PI() Function
The SQL Server PI() function returns the value of PI.
SQL – SQL Server POWER() Function
The SQL Server POWER() function returns the value of a number raised to the power of another number.
SQL – SQL Server RADIANS() Function
The SQL Server RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.
SQL – SQL Server RAND() Function
The SQL Server RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
SQL – SQL Server ROUND() Function
The SQL Server ROUND() function rounds a number to a specified number of decimal places.
SQL – SQL Server SIGN() Function
The SQL Server SIGN() function returns the sign of a number.
SQL – SQL Server SIN() Function
The SQL Server SIN() function returns the sine of a number.
SQL – SQL Server SQRT() Function
The SQL Server SQRT() function returns the square root of a positive number.
SQL – SQL Server SQUARE() Function
The SQL Server SQUARE() function returns the square of a number (the number times itself).
SQL – SQL Server SUM() Function
The SQL Server SUM() function calculates the sum of a set of values. NULL values are ignored.
SQL – SQL Server TAN() Function
The SQL Server TAN() function returns the tangent of a number.
We’d like to acknowledge that we learned a great deal of our coding from W3Schools and TutorialsPoint, borrowing heavily from their teaching process and excellent code examples. We highly recommend both sites to deepen your experience, and further your coding journey. We’re just hitting the basics here at 1SMARTchicken.
Why 1SMARTchicken?
See More →
Thanks for your support!
SQL Books
All are affiliate links. Thank you for your support!
SQL NOTES:
- Any work being done to modify the structure of a database or delete tables or the the database itself should only be done after making a recent backup
Feedback
If you see an error on the page or the code itself is incorrect or incomplete, or just plain wrong, please let us know. We’re always learning. NOTE: we do not sell your information and will not send you spam emails.