All authors

Technical Article

Split Function

This is another type of split function which disects 8000 byte varchar with given delimeter and returns table with disected values.It does that with single select statement (internally looped), without using explicit while loop.Works pretty fast

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-02-06 (first published: )

395 reads

All authors

Blogs

Webinar: Navigating the Database Landscape in 2026

By

For a number of years, we’ve produced the State of the Database Landscape report,...

Claude AI Convinced Me Not to Build an iPad App

By

I coach volleyball and I do a lot of stat stuff on paper. I...

A New Word: Dolorblindness

By

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Read the latest Blogs

Forums

The Power of Data and Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Power of Data and...

What's the Date?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the Date?

Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Two New Shortcuts for Fabric...

Visit the forum

Question of the Day

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

See possible answers