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 |
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
 Posted - 2002-03-06 : 05:29:46
|
| Hi all,I have a field as image data type. I want to retrieve the information from the blob field and to stored received data into local variable. However I choose a varbinary data type for the local variable, but it has a limit to 8000 symbols. Is there any way to stored blob data in a local variable without any limit and what should query look like?Thanks in advance.The Rebel |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-06 : 07:12:49
|
| Nope, that's the best you can do as far as variables are concerned.You can extract portions of the column using the READTEXT command (check Books Online), but you can't do much with the results (you can't put a piece of it into a variable, you can only read it and display it) |
 |
|
|
|
|
|
RETRIEVE BLOB