[Script Of Oct. 16] How to split comma-delimited string column into multiple records in SQL Server

image

Oct.

16

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-split-comma-90a35ace.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This T-SQL script will demo how to split comma-delimited string column into multiple records in SQL Server.

As many people asked how to split comma-delimited string column into multiple records in SQL Server, we create a table for demonstrating.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery