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

194 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

Error switch partition

By samirca007

hello Good morning all I want to switch the partition from one table to...

SQL Patching implementation date

By WhiteLotus

Hi I am looking at the script to get SQL Patching implementation date ....

TDE / SQL server Database / SSIS

By hurricaneDBA

Dear Everyone We have implemented a data warehouse on-premises using SQL server 2019 enterprise...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers