Quickly Format a Number to 2 Decimal Places in SQL Server скачать в хорошем качестве

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