Published on Aug 12, 2017:
In this video, we will learn to find left part of a string till a specified number of characters:
Please find below the final SQL used for obtaining the result:
--String Declaration
Declare @StringVar as nvarchar(255)='Hey Mate !! What is up??';
-- Left Function
Select Left(@StringVar,10) as LeftOfString
You can get more details about the left function by referring to the microsoft site by clicking the link below:
https://goo.gl/DnefSo
Previous Video: • First word of a sentence SQL Server
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server!
/ @learnexcelrelentless
Download the sample database used for the demo here: https://goo.gl/SVyVmT
Our Playists:
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
In questa pagina del sito puoi guardare il video online Left Function SQL Server della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Learn 2 Excel 12 agosto 2017, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 365 volte e gli è piaciuto 2 spettatori. Buona visione!