Importing photographs into a table, very simple
From MyWiki
CREATE TABLE ImageTable ( Id INT, Name VARCHAR(50) , Photo varbinary(MAX) ) INSERT INTO ImageTable (Id, Name, Photo) SELECT 1, 'test', BulkColumn FROM Openrowset( Bulk 'C:\test.jpg', Single_Blob) AS image UPDATE ImageTable SET photo= (SELECT BulkColumn FROM Openrowset( Bulk 'C:\IMSpics14_15\33105810.jpg', Single_Blob) AS image)