MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter


















Trending SQL Server Tips






SQL Server 2016: STRING_SPLIT and STRING_ESCAPE T-SQL Enhancement in SQL Server 2016

Read Comments   |   Related Topic: TSQL Enhancement SQL Server 2016 > Next Topic: FORMATMESSAGE Statement


Click here to read about new T-SQL enhancements in SQL Server 2016 from the beginning...

STRING_SPLIT Function and STRING_ESCAPE Function in SQL Server 2016

SQL Server 2016 introduces two new string functions namely STRING_SPLIT and STRING_ESCAPE.

STRING_SPLIT: This string function can be used to split the character expression using the specified separator.

For more information, see STRING_SPLIT (Transact-SQL).

Syntax: STRING_SPLIT (string , separator)
Example: SELECT STRING_SPLIT('MyTechMantra Helps DBAs and Developers Daily', ' ');	
Output

MyTechMantra
Helps
DBAs
and
Developers
Daily

Related Tips

SERVERPROPERTY T-SQL Enhancement in SQL Server 2016
TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
DROP IF EXISTS T-SQL Enhancement in SQL Server 2016
ALTER TABLE WITH (ONLINE = ON | OFF) T-SQL Enhancement in SQL Server 2016
MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP

Thank you for taking your time to read this article. Let's be Connected....

Sign-up for Our Newsletter to Get Free SQL Server Tips and News to Build your Career

Like MyTechMantra on Facebook to get updates on What's Happening in SQL Server

STRING_ESCAPE: This function can escape special characters within texts and will return text with escaped characters. For more information, see STRING_ESCAPE (Transact-SQL).

Syntax: STRING_ESCAPE(text , type)

Click the Next Page button to continue reading about New T-SQL enhancements in SQL Server 2016 and click on the Previous Page button to revise the previouly read topic.

Previous Page.. Next Page..




Learn More...





Last Updated On: May 16, 2016



Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips




Please leave your Valuable Comment or Let us know how this article helped you: