Ashish Mehta
|
 |
|
SQL Server 2016 introduces two new string functions namely STRING_SPLIT and STRING_ESCAPE.
This is Part 8 of 10 Part T-SQL Enhancements in SQL Server 2016 for Developers and DBAs.Click here to read it from the beginning….
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
DailyRelated 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
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)Clicking Next Page button to continue reading the topics and click on the Previous Page button to revisit the previous topic.
|
|
|
|
Trending Tips
- How to Repair Suspect Database in SQL Server | DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS | Repair Suspect Database
- COPY_ONLY Backup in SQL Server Step by Step Tutorial with Examples
- Download SQL Server 2014 Developer Edition Free
- SQL Server: How to Start SQL Server with Minimal Configuration
- SQL Server: How to Start SQL Server in Single User Mode?
- Download SQL Server 2016 Developer Edition for Free
- Fix Cannot open user default database. Login failed. Login failed for user SQL Server Error
Chetna Bhalla