Local Text Larger then 8000

[PaulBarbeau]

How do you have a local text varable larger then 8000?

 

[JamesLean]

Simple answer - you don't. Local variables cannot be text, ntext or image data types, which are the only types that allow more than 8000 chars.

--James

 

[LinsLo]

James,

Is there any work around for this. Here is the post I just made:

Here are the details of what I am trying to do.

I have a procedure which has a incoming parameter that is an ID. Based on that ID I want to then perform a select statement that will select a field of type text from a table where a column matches with that ID. Then, I want to call a procedure and pass it the text variable which was just obtained. This is where I run into the error that I can not have a local variable of type text, ntext or image. Any ideas? I have tried selecting straight in for the parameter of a procedure but that doesn't work either.


Any suggestions would be greatly appreciated!

Lindsay

 

[SQLSister]

Rather than use a procedure inside a procedure, why not just call it directly in the calling procedure?

Just add it as another field in the query. Use your select asa derived table if necessary.

Questions about posting. See faq183-874