Rounding a number to 2 decimal places in SQL SERVER

February 16, 2013 admin

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

September 9, 2021 admin

Formatting DateTime to Date in SQL SERVER

February 16, 2013 admin

Finding duplicates with SQL?

February 15, 2013 admin

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

December 4, 2021 admin
guru able angular 2 template web

17 Of The Best Rated Angular 2 Website Templates

November 28, 2021 admin
pogody website template angularjs

The 16 Best Responsive AngularJS Templates?

November 27, 2021 zeeshan

Replace SQL Server new line with HTML

September 9, 2021 admin
kids care children wordpress theme

Best WordPress Themes for Kids Website

August 17, 2020 admin