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 2005 Forums
 Transact-SQL (2005)
 Huge Strings / text

Author  Topic 

asafg
Starting Member

39 Posts

Posted - 2008-12-08 : 11:20:40
In a previous post someone helped me getting the text of a stored procedure.

Yet is is broken to a number of records.
I thought it will be easy to concatenate the lines, but I forgot that there is a 8000 chars limit to the varchar

Is there another way to handle huge strings?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-12-08 : 11:32:11
you have posted this under "Transact-SQL (2005)".
In 2005 you can use varchar(max).

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -