Technical Article

Parse String into Table

This script takes a string of up to 8000 characters with a single character delimtier and returns a table with each substring in its own row. A identity column is also returned so you can easily find the n'th item in the list.Script is similar to kmlakov's but doesn't require the item count and adds […]

2006-02-21 (first published: )

1,242 reads

Blogs

Daily Coping 27 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Fixing a giant or running a SQL Server project deployment with Temporal tables

By

(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...

Azure Cosmos DB introduction

By

Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...

Read the latest Blogs

Forums

Upgrading many rdl files to SSRS 13

By OkReboots

In process of upgrading SQL Server from 2005 to 2016 we find that some...

SQL Always Encrypted - I don't get it

By rann

HI, I really tried to understand this, but its seems beyond me. In many...

Alter table add identity column with (online=on)

By daytonbrown2

Using 2017 enterprise edition.  I'm guessing that adding an identity column to a table...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers