dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Explore a Few Math Functions in SQL Server

See several math functions that can be used in T-SQL.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


There are a number of math functions in T-SQL. Here are a few of them:

SELECT SQRT(49) --Gives 7, Square Root

SELECT PI() --Gives 3.14 .... PI

SELECT ROUND(15.30, 0) --Gives 15. Rounds a number

SELECT CEILING(49.32) --Gives 50. Finds the next highest Integer value

SELECT FLOOR(49.32) --Gives 49. Finds the next lowest Integer value

 

Visit the DevX Tip Bank

 





   
Thanks for your registration, follow us on our social networks to keep up-to-date