SQL Server Performance Forum – Threads Archive
Image to SQL Server
How can I take several pictures from a place on my hard drive, like c:documents and settings, and insert them at once into a SQL server DB so I can use them in SQL Reporting Services? Joe Jankahttp://www.sql-server-performance.com/asp_sql_server.asp for ways of handling images in SQL server.
Also search under this forum other useful tips on managing images in SQL server database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The problem with that is that there are about 6,100 pictures, i am creating a report making a letter to be sent out with a picture of the product i am referring to in the body of the letter, so its not really for the web. none of the pictures is above 59K and total they are 170 M. what is the load procedure because I know SQL Server does not have a function to pull them in by itself Joe Janka
quote:The problem with that is that there are about 6,100 pictures, i am creating a report making a letter to be sent out with a picture of the product i am referring to in the body of the letter, so its not really for the web.
How about leaving pictures where they are and storing in db full file name? I guess you are not going to retrieve information based on column containing image, so better do not store them in db.
]]>