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 |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2009-07-10 : 01:40:26
|
| Hi, I have images stored in Sql Server Database (field type : Image)How can i view those image using Transact Sql Any help regarding this will be appreciated. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-10 : 01:44:49
|
| It can be done with the help of your front end application!You must read the column (image) and decode it on the required file format!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-07-10 : 01:58:13
|
| no soln other than front end application!Is there and TSQL ? |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-10 : 02:05:54
|
quote:
Originally posted by sagitariusmzi
no soln other than front end application!Is there and TSQL ?
Up to my knowledge front end is the solution!Let we wait and see if any alternate in T-sql is available  Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-10 : 15:35:41
|
| Could you use tsql to export the field to a txt file and rename it? |
|
|
|
|
|
|
How to view images stored in sql server