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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-03-17 : 08:19:57
|
| Everyone says keep files externally with a reference / pointer in a row. Text in row option...But if the datatype is image, what's with all this hassle I hear about? I see regular reports with .bmp data displayed plain and clear. I can get a textptr to the object I want to see. Why can't I do aSELECT image from <table> and see the picture? Can it be done within SQL at all? All I need to do is read images with WHERE conditions setAre there system procedures I can find to do this? These images are being written in every day! I need to read them for a report! Not READTEXTThe data is a signature, by the way, on a PDA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-17 : 22:48:05
|
| Sql2k comes sample code for that, you can install sample code from sql2k cd abd take look at it. It's not by t-sql statement. |
 |
|
|
|
|
|
Image in Database