Adding leading characters in SQL Server: REPLICATE, SPACE and REVERSE

Pubblicato il: 01 settembre 2021
sul canale di: SQL Server 101

3,434

In this video, we will be looking at a few final string functions: REPLICATE, SPACE and REVERSE.
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
----
The REPLICATE function allows you to repeat a string as many times as you need. This can be useful for creating leading zeroes, when used in conjunction with the RIGHT function.
If you just want spaces, then you can use the SPACE function instead.
Finally, if you want a string to be shown backwards, use the REVERSE function.

In questa pagina del sito puoi guardare il video online Adding leading characters in SQL Server: REPLICATE, SPACE and REVERSE della durata di ore minuti seconda in buona qualità , che l'utente ha caricato SQL Server 101 01 settembre 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 3,434 volte e gli è piaciuto 22 spettatori. Buona visione!

4,532,360

129K