Substring Function SQL Server скачать в хорошем качестве

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