Storing text and images
Can anyone tell me how to go about storing data that includes both text and images? Let's say you wanted to have an article record that had an article id and the article information. Is there any way to lump all the text/image data into a field in SQL, or would you have to somehow manually break it up and store everything in different fields?
Posted Sep 1, 2009, 12:13 AM
Vijaya KadiyalaPosted Apr 22, 2009, 3:52 PM
Hi
Dont use Image Data type. It is going to be removed in future versions of the SQL Server.
Instead of storing this in a database, store the Document or image in filesystem and store the location of the objects in Database table. This way its going to very easy to modify this from front-end application.
Thanks
-- Vijaya Kadiyalawww
.DotNetVJ.comramesh pPosted Apr 21, 2009, 3:48 AM
please check this link:
http://www.dotnetspider.com/resources/460-Store-Retrieve-SQL-Server-database.aspx
ramesh pPosted Apr 21, 2009, 3:47 AM
please check this link:
http://www.shabdar.org/store-save-images-in-sql-server.html
venkata naiduPosted Mar 15, 2006, 9:02 AM