SQL Server ASCII and CHAR functions, including tabs and carriage returns

SQL Server 101
SQL Server 101
7 هزار بار بازدید - 3 سال پیش - In this video, we will
In this video, we will be looking at how to convert single characters to numbers and back. This also includes non-printing characters, such as tabs, line and carriage returns.
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
----
In this video, we will look at:
ASCII - converting a single character to a number between 0 and 127 (or 0 and 255)
CHAR - converting a number between 0 and 255 to a single character. This includes CHAR(9) which is a tab, CHAR(10) which is a
NCHAR - converting a number from 256 upwards to a single Unicode character.
UNICODE - converts a single character from the extended character set to a single number.
3 سال پیش در تاریخ 1400/04/23 منتشر شده است.
7,038 بـار بازدید شده
... بیشتر