[Script Of Apr. 28] How to split a row into several rows by delimiters in a SQL Server table

image

Apr.

28

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-split-a-row-into-4a966df3.  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 script is used to split a string into strings by delimiters. The script will demonstrate the process by creating a test table and a stored procedure. We can see from the result of the original table and the final table.

As some people asked how to split a string in a row into multiple strings and put the strings into rows, this script will provide some help. You will create your own with the reference of this script.

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