Substring Function SQL Server
Published on Sep 04, 2017:
In this video tutorial, we will learn to get the subset of a string using the substring function.
Documentation for the substring function can be found at the below location:
https://goo.gl/fd3bw2
SQL used in the example is copied below.
Select 'Hello World!!!' HelloWorld
Select Substring('Hello World!!!!!',6,11) HelloWorldSubset
SELECT
[EnglishMonthName]
,Substring(EnglishMonthName,1,3) MonthShortName
,[MonthNumberOfYear]
,[CalendarQuarter]
,[CalendarYear]
,[CalendarSemester]
,[FiscalQuarter]
,[FiscalYear]
,[FiscalSemester]
FROM [AdventureWorksDW2012].[dbo].[DimDate]
Previous Video: • Convert number to a string
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 Substring Function SQL Server della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Learn 2 Excel 04 settembre 2017, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,142 volte e gli è piaciuto 4 spettatori. Buona visione!
