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 - 2005-02-21 : 08:27:51
|
Saurabh writes "actually i have stored a string of more then 8000 characters in stored porcedure 1n sql server 8.0 but as u know that it won't be possible in varchar and text is not supported in stored procedure as it gives an error 175 i.e we cannot use text datatype in local .So what would be the right solution for it. plz. mail me as soon as possible with the solution.This is the statement that you have write below this text box and this is my problem. As i have to create a dynamic mail matter through stored procedure of more then 8000 characters but the limit is 8000 of varchar "Yes, you can use HTML in your question but please try to limit it. Please include SQL Server and Windows version including service packs. If you want to put in a table or columns that should line up, please enclose it in and tags. And please keep it under 4,000 characters. Thanks."" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-21 : 08:40:59
|
one option is to split the data into say 4 8000 long varchars whic then you put together into a text column.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
how to use Text datatype in stored procedure in sql server 8.0