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 |
|
pankaj keshari
Starting Member
1 Post |
 Posted - 2010-11-03 : 03:05:30
|
I have Image data type of a column, value are stored in that column,can i know with help of that string ,what value are stored in that column like Doc file , image , exe, text string etc. Pankaj KeshariMember of Technical Services |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-11-03 : 07:37:52
|
| AFAIK it's not possible as the data is saved in binary format.Maybe you can do one thing add another column to the tables say "extension" and let the application save the file extension to that column.PBUH |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-11-03 : 08:29:56
|
Almost always the first four bytes denotes the type of document.TIFF images almost always starts with "TIFF" and so on... Give it a try!
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
Get information with image data type field