This tutorial is about how to split a delimited text into multiple independent columns with SQL Server. Working with comma or semi-colon delimited data often requires efficient and effective manipulation techniques. A common task is to split a single text variable into multiple columns.<\/p>\n\n\n\n
This is particularly useful for preparing CSV file imports or restructuring data. In this article, we’ll explore a straightforward method to achieve this using T-SQL. Indeed, in the previous tutorial about splitting strings, we discussed how to split a delimited text stored in a variable into one single column<\/a><\/strong>, one value per column. <\/p>\n\n\n\n Table of Contents<\/p>\n<\/span><\/div>\n