parsename – CodeRavo

Efficiently Splitting and Accessing Items from Delimited Strings in SQL Server

Introduction to String Manipulation in SQL Server In database management, there are often scenarios where data … Efficiently Splitting and Accessing Items from Delimited Strings in SQL ServerRead more

common-table-expressions, delimited-strings, parsename, split function, SQL Server, string manipulation, user-defined-functions

Efficiently Splitting Comma-Separated Strings into Columns in SQL

When working with databases, you often encounter scenarios where data stored as comma-separated values (CSV) within … Efficiently Splitting Comma-Separated Strings into Columns in SQLRead more

CHARINDEX, cross-apply, parsename, SQL Server, string manipulation, substring, xml-parsing