Allow me to save your life and career as an SQL Developer with a bit of advice... do not store images in an SQL Server table... store the file names of image files, instead. You can't display images in SQL Server, anyway... so pass the path and file name of the image back to the app, instead. Let the app get the image from that.
Storing/retrieving images directly in SQL Server tables is slow and one of the worst things you could do to a database.
Of course... that's just an opinion :)
--Jeff Moden
|