Split Function for T-SQL using XML
Posted by Tim on July 29, 2009 in SQL Server |
Here is some sample code to split a string and return the results via a table.
CREATE FUNCTION [dbo].[split]
(
@del char(1),
@str varchar(max)
)
RETURNS @tResult TABLE
(
val varchar(max)
)
AS
BEGIN
declare @xml xml
set @xml = N’<root><r>’ + replace(@str,@del,’</r><r>’) + ‘</r></root>’
insert into @tResult(val)
select
r.value(‘.’,'varchar(max)’) as item
from @xml.nodes(‘//root/r’) as records(r)
RETURN
END
1 Comment
Leave a Reply
You must be logged in to post a comment.
-
-
-
CodeLab Twitter- codelabnz: @possiblyb9 I now have blackberry for breakfast February 7, 2012
- codelabnz: I have now joined most ppl in indonesia and got myself a blackberry February 7, 2012
- codelabnz: From a bb February 6, 2012
- codelabnz: @bartekmarnane some info on micro orms http://t.co/UDfv5ML7 February 5, 2012
- codelabnz: @bartekmarnane depends on the project, but i found u have 2 be very careful with EF and the type of SQL it generates February 5, 2012
- codelabnz: @bartekmarnane I have been using EF for awhile, good for building apps quickly, but found it performs bad on higher traffic web applications February 5, 2012
- codelabnz: stuff it, I give up on Entity Framework, going to a micro ORM, back to writing SQL queries! I would rather do this than have a slow app! February 5, 2012
- codelabnz: Been too busy for tweeting lately January 21, 2012
- codelabnz: Blog Post: Setting the screen position when visiting previous page with jQuery http://t.co/evuKxVv0 January 17, 2012
- codelabnz: is anyone using Godaddy Cloud hosting? can someone provide their website so I could do a speed test? January 9, 2012
[...] found the following function using XML and am reposting it here for future reference. Thanks to http://blog.codelab.co.nz/2009/07/29/split-function-for-t-sql-using-xml/ for the [...]