Скачать или смотреть Quickly Format a Number to 2 Decimal Places in SQL Server

Here's a quick video to show you how to format a number to two decimal places in SQL Server. You can of course also use this technique to round numbers to other numbers of decimal places.

00:14 - Round a variable
00:49 - Round a column value
01:22 - Round integers up or down

Rounding numbers to a specific number of digits in SQL Server is easy - you just need to use the ROUND function:

DECLARE @myNumber FLOAT
SET @myNumber = 12.4856757
SELECT ROUND(@myNumber, 2)

If you want more control over the rounding process then at 01:22 I also show you how to use the CEILING and FLOOR functions.

If you found this video leave a LIKE and SUBSCRIBE for more coding videos.

Check out my SQL Programming playlist for more tutorials:    • SQL Programming  

Stock footage credits: https://www.pexels.com/@pressmaster and https://www.pexels.com/@artempodrez