Rounding a number to 2 decimal places in SQL SERVER

admin February 16, 2013 0

Use T-SQL Convert Function.



Select convert ( decimal(8,2) , 9.4125 )

Output: 9.41

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I agree to have my personal information transfered to Mad Mimi ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Related Posts

More Stories

Replace SQL Server new line with HTML

admin September 9, 2021 0

Formatting DateTime to Date in SQL SERVER

admin February 16, 2013 0

Finding duplicates with SQL?

admin February 15, 2013 0

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You may have missed

touch light wordpress theme mobile

15+ Top Mobile Themes For WordPress

admin December 4, 2021 0
guru able angular 2 template web

17 Of The Best Rated Angular 2 Website Templates

admin November 28, 2021 1
pogody website template angularjs

The 16 Best Responsive AngularJS Templates?

zeeshan November 27, 2021 0

Replace SQL Server new line with HTML

admin September 9, 2021 0
kids care children wordpress theme

Best WordPress Themes for Kids Website

admin August 17, 2020 0