470,855 Members | 1,143 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,855 developers. It's quick & easy.

"Storing an image into Sql Server Database "

Is there any way of storing an image file into a specific Table .
It would be of great help for me if i come to know something about it.
Jul 23 '05 #1
2 1540

One simple way is to store the physical path of the image

Madhivanan

Jul 23 '05 #2
(sa*********@indiatimes.com) writes:
Is there any way of storing an image file into a specific Table .
It would be of great help for me if i come to know something about it.


You can use the image datatype. You can also opt to store the image
in the file system and store only the path in the database as
Madhivanan suggested. This latter is simpler to implement, in the
short-term at least, but is less reliable since you have poorer
transaction scope, the file can more easily disappear.

Thus using image is more robust, but admittedly it takes more code to
come there.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by BKDotCom | last post: by
2 posts views Thread by Mr.Clean | last post: by
5 posts views Thread by Mark Woodward | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.