SUBSTRING () - Extract characters from a text field
Example: - Below is the simple example of SUBSTRIGN function
DECLARE @STRING VARCHAR(50)='EXAMPLE OF SUBSTRING FUNCTION'
SELECT SUBSTRING(@STRING, 1, 7)
This gives the Result: - EXAMPLE
About Alok Singh
I have done postgraduate with Master in computer Application (MCA) degree. I am working on Microsoft Technologies from 2009 using C#, MVC, ASP.Net, Web API, JavaScript, JQuery, LINQ, Entity Framework, KnockoutJs, Kendo UI, WCF, SQL Server etc.
I have 8+ years experience as “Software Developer” in Health, Telecom, Legal Industry and Gaming domains using the above mentioned technologies
Sql Server 2012- Date time new function Following are the seven new date time functions have been introduced in SQL Server 2012 1:- DAT...
No comments:
Post a comment