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 |
|
se.pavan
Starting Member
1 Post |
 Posted - 2008-05-22 : 07:23:52
|
| Hi,I am working on a stored procedure that creates an excel sheet and fills each row with data. Now my requirement is to add a row with much more than 8000 characters in a row. For that I need to have a variable with the length more than 8000. I can't use varchar, as its length is maximum 8000 in SQL server 2000 and I also cant use a variable of type TEXT in a stored procedure. Can anybody help me to know if we have any other way to handle it.Thanks & Regards,Pavan |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-05-22 : 08:13:51
|
| You can use TEXT parameters in SPs (just not as local variables). So if you have a TEXT input variable, you can call your SP from an application and set the value to a large string from your application code. What technique are you using to populate Excel and from where is the 8K+ data originating?Be One with the OptimizerTG |
 |
|
|
|
|
|
How to use a variable with more than 8000 size