How to Add Commas to Numbers in SQL Server скачать в хорошем качестве

How to Add Commas to Numbers in SQL Server

If you find this SQL tutorial useful please LIKE and SUBSCRIBE! In this video I show you how to add comma separators to numbers in SQL Server. 00:00 - Introduction 00:14 - Formatting numbers 01:05 - Formatting currency 01:19 - Language considerations 02:30 - Alternative method 03:06 - When NOT to use this technique As I explain in the video, formatting numbers in the data layer is generally not considered to be good coding practice. You should ideally format numbers in the presentation layer using formatting functions available in coding languages such as C#, Java or JavaScript. Also be aware that not all countries standardize on using commas as thousands number separators. For example Germany uses a period and Sweden uses spaces. However if you're just creating reports using SQL Server itself then this technique can be very useful. Useful transact SQL queries: Format a number to a rounded integer using FORMAT (SQL Server 2012 and above): SELECT FORMAT(25000, 'N0') SELECT FORMAT(25000,'#,##0') Format using rounded decimal places: SELECT FORMAT(25000, 'N2') Format as currency using the current system language: SELECT FORMAT(25000, 'C2') Number formatting in Microsoft technologies: https://docs.microsoft.com/en-us/glob... Number formatting in .NET Framework: https://docs.microsoft.com/en-us/glob... Custom numeric format strings: https://docs.microsoft.com/en-us/dotn...