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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-18 : 13:55:08
|
Rajesh writes "Hi,
We have a stored procedure which will return an xml string as an output parameter. The xml string is built using the data retrieved from the database. But the xml string length exceeds 8000 char limit. Stored procedures can handle only 8000 characters and also its output parameter can not exceed that limit. We thought of making it as text variable. If we make it as text , we are not able to append varchar to this. And also we will not be able to output text as the output parameter. How can we get rid of this problem. I think in oracle ther is no limit in this. Is it a limitation in SQL Server. Kindly guide me.
regards
Rajesh" |
|
|
|
|
|
SQL Varchar limit and Text