Rounding a number to 2 decimal places in SQL SERVER

Use T-SQL Convert Function.

[code]
Select convert ( decimal(8,2) , 9.4125 )
[/code]

Output: 9.41

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

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

Leave a Reply

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

CommentLuv badge