SPLIT function

This is a port of the SPLIT function from Perl (or VBScript). It works the same way: pass a string anda separator, up to 4 characters long (you can change this),and the function returns a table with the elements.This version trims leading and trailling spaces of the elements, just for convenience.Example:SELECT    strvalFROM    master.dbo.SPLIT('a and b', […]

5 (1)

2003-06-13

189 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

CPU?Memory and IO bottleneck check

By 892717952

Which indices will show  cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers