У нас вы можете посмотреть бесплатно Converting numbers to strings in SQL Server: STR and FORMAT functions или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
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).