dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
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

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

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date