Treat Yourself to Fn_Split()

Rating:

(0)

Burton Roberts

SQL Server Magazine

InstantDoc ID #21071

This UDF lets you emulate VB's Split() function and parameter arrays

Hardly a week goes by in the newsgroups that a SQL Server developer doesn't ask how to pass a variable-length parameter array to a stored procedure--and learns that the technique isn't possible. You can use variable-length parameter arrays in Visual Basic (VB), but what if you prefer to program in T-SQL? Last year, I took advantage of SQL Server 2000's new support for user-defined functions (UDFs) to ...

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

Monthly or Annual

Professional Membership

VIP Membership

Compare Member Benefits

Add a Comment

very useful - thank you

Geoff3/15/2007 1:12:42 PM

it is pretty good and works nicely until the length of your delimeted string is bigger than 8000 characters. other than that works like a charm.

daniel

dan1828/31/2004 8:28:13 AM

SQL Server really forgot A LOT of functions to make our lives easier. More articles like this REALLY saves time - Burton Roberts should work for MS! LOL

dennis5/3/2004 10:10:37 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

The Essential Guide to SQL Server Skills for the Oracle DBA
A Essential Guide by AMD

The Essential Guide to Jump Starting Your SQL Server Skills
A Essential Guide by Quest Software

SQL Server Administration for Oracle DBAs
A EBook by Microsoft

Special Report: Perspectives on SQL Server Sprawl
A Essential Guide by PolyServe

Field data type change - query timeout

Hi, I need to change a data type of a field in SQL Server 2005. The fiels most be changed from varchar(13) to varchar (20), but because of th...222-96220