Importing photographs into a table, very simple

From MyWiki
Revision as of 13:48, 13 March 2017 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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)