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: )

392 reads

All authors

Blogs

Speaking at the NYC Lunch and Learn DevOps Devour Hour

By

This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

Read the latest Blogs

Forums

Deadlocks and Backups - Need help

By Mike-342950

Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...

Does Version Control Scare You

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Does Version Control Scare You

Unlimited Text

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unlimited Text

Visit the forum

Question of the Day

Unlimited Text

If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?

See possible answers