Variable with more than 8000 characters

Question

Variable with more than 8000 characters

joemai

Hall of Fame

Points: 3496
More actions
June 6, 2007 at 3:07 pm

#117488

I'm writing store procedure with more than 8000 characters because of the HTML data. I must declare a variable to hold that data; however, SQL2K's variable does not allow more than 8K of characters. Is there a way to go around this?
Please help and thanks for your support.

Minh Vu

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

David McFarland SSChampion Points: 11815 More actions · Answer 1

Short of upgrading to 2005, the typical method (even MS uses it for storing stored procs, for example), is to split the data into more than 1 row, with some sort of unique identifier to group them together, and a step value to order them. Then it can be put back together easily. It's not in a variable then, but it's often close enough to accomplish the task.

joemai Hall of Fame Points: 3496 More actions · Answer 2

Thanks so much for the hint. Let me try that way to see.

I'm really appreciate your help.

Minh Vu

joemai Hall of Fame Points: 3496 More actions · Answer 3

It did not work for me at all since later I need to pass in parameter for sp_OAsetproperty. The limit for this system sp is also 8K I guessed.

Anyone has any other ideas. This is really tough.

Minh Vu

David McFarland SSChampion Points: 11815 More actions · Answer 4

I'm still not seeing why it wouldn't work, but you haven't give us much to work with here in the way of details. Since that system stored proc just sets properties, it shouldn't matter what you send it. You could easily set that property to an identifier instead of the full text of the html, for instance.