Converting numbers to strings in SQL Server: STR and FORMAT functions скачать в хорошем качестве

Converting numbers to strings in SQL Server: STR and FORMAT functions

In this video, we will be looking at how to convert numbers to strings in SQL Server. My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft... 98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv... ---- My Excel for PC courses are: Beginner to Excel - https://rebrand.ly/microsoft-excel-sp... Intermediate to Expert Advanced - https://rebrand.ly/microsoft-excel-ex... Power Table, Get and Transform and Power Pivot - https://rebrand.ly/visualizing-data-e... VBA macros for Excel - https://rebrand.ly/excel-vba-pc ---- You can't join a string to a number using the + sign, as SQL Server would try to convert the string to a number, rather than the other way round - you would probably get an error. Instead, you need to convert the number to a string first, and then you can join two strings together. There are two main functions to consider. STR converts a number to a string, and you can specify the total length and the number of decimal places. The FORMAT function gives you a lot of customisation, including locale-aware formatting (using the .NET framework formatting patterns and culture).