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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How can I display Image fields in SQL Server 2008

Author  Topic 

jooorj
Posting Yak Master

126 Posts

Posted - 2011-04-27 : 04:35:39
how can I display Image fields in SQL Server 2008 ?
directly without using other software only using MMS ..

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-04-27 : 05:04:06
sql server isn't a tool to display images.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-04-27 : 05:23:09
Joorj, you are asking a lot of questions lately that have the answer in Books Online.
Give Books Online a try!

This will give you your image in binary representation
SELECT {My image column name here} FROM {My table name here}




N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

jooorj
Posting Yak Master

126 Posts

Posted - 2011-04-27 : 06:52:27
Peso, what is that mean online
is my question to display image as image found in Books Online ?
I need to see image.
I do not want to display image as text as you say 'SELECT {My image column name here} FROM {My table name here}' this is Wrong.
please read my question carefully .OK
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-04-27 : 08:26:48
1) SQL Server is a database server. An application to store data.
2) SQL Server doesn't build images for you. That's what the GUI do, like Microsoft Access which has a GUI built on top of the database.
3) Access and SQL Server are different products.

Books Online is the documentation about SQL Server, the product you are using. It's available online too.
Books Online is the SQL Server help file.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

jooorj
Posting Yak Master

126 Posts

Posted - 2011-04-27 : 15:59:26
thank u
Go to Top of Page
   

- Advertisement -