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 - 2002-05-30 : 08:53:34
|
| Susana writes "I want to execute a select with 16.000 characters in a stored procedure, and I can't pass it to the sp, in a parameter.I try to use a ntext variable, but I can´t declare it as a local variable.How can I resolve this problem?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-30 : 08:56:49
|
| Take a look here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16353And read the links included in that thread.The only practical way to do this is to use multiple varchar variables executed like this:EXEC (@sql1 + @sql2 + @sql3)You can't do it using text variables because they cannot be manipulated. Also, unless you are certain that you have international characters, use varchar instead of nvarchar, it's much easier. |
 |
|
|
|
|
|
Long String in a Stored Procedure