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
 General SQL Server Forums
 New to SQL Server Programming
 updating an image

Author  Topic 

mana
Posting Yak Master

102 Posts

Posted - 2014-12-07 : 12:19:37
hello

i have an image column in a table in sql server and i want to assign a picture to all of the rows of this column. But i am new to sql server and i don't know how i should do it exactly. can you help me please?
Thank you

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2014-12-07 : 13:42:55
Images will be stored in your table in binary format .check the datatype of that column.

http://www.sqlhub.com/2009/08/insert-and-update-image-field-in-sql.html

Vijay is here to learn something from you guys.
Go to Top of Page

mana
Posting Yak Master

102 Posts

Posted - 2014-12-07 : 15:39:29
Hello

thank you for your reply
i tried this link out
what saved is in binary format
but i need the exact image
do you know what i cna do ??






quote:
Originally posted by vijays3

Images will be stored in your table in binary format .check the datatype of that column.

http://www.sqlhub.com/2009/08/insert-and-update-image-field-in-sql.html

Vijay is here to learn something from you guys.

Go to Top of Page

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2014-12-10 : 10:49:18
According to your Question u are trying to display images in Database table corresponding to each row, am I correct?

If that is the situation so you can not load and display Images in tables .Images will be stored in binary format and u can pull the binary data to any loaction in ur system where u can see the real image.




Vijay is here to learn something from you guys.
Go to Top of Page
   

- Advertisement -