Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Large string parsing..

Author  Topic 

keyursoni85
Posting Yak Master

233 Posts

Posted - 2013-05-28 : 06:41:44
I have comma separated string with 5000 records and string with comma is too big..

I tried number of functions for split string to table with comma and failed due to varchar limit.

I cannot post that string here.

Can I have that function which can run with nlength?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-05-28 : 06:52:43
Check this link.. this might be helpful to you
http://stackoverflow.com/questions/6460699/splitting-a-very-large-string-with-a-custom-delimiter
http://www.sqlperformance.com/2012/07/t-sql-queries/split-strings

--
Chandu
Go to Top of Page

keyursoni85
Posting Yak Master

233 Posts

Posted - 2013-05-28 : 06:55:01
yes, thx.
used nvarchar(max) for large strings..
Go to Top of Page

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-05-28 : 07:19:35
quote:
Originally posted by keyursoni85

yes, thx.
used nvarchar(max) for large strings..


Welcome

--
Chandu
Go to Top of Page
   

- Advertisement -