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 - 2004-05-03 : 10:42:31
|
| Rashmi writes "Hi !Im stuck with this problem i hope u can help me resolve.... I m calling a stored procedure giving a input parameter which is varchar datatype.. but my input string goes beyond 8000 characters which is max limit. I cannot use text datatype coz its not acceptable as local variable ... i hope there is a way out of thisanxiously waiting 4 response from ur side" |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-05-03 : 10:50:20
|
| you could try breaking it into 2 separate strings, but you will meet the same problem utilising it anywhere because it will be too large to store in a rowGraham |
 |
|
|
|
|
|
sql server 2000 VARCHAR datat ype