https://wiki.twig.es/index.php?action=history&feed=atom&title=Importing_photographs_into_a_table%2C_very_simple
Importing photographs into a table, very simple - Revision history
2026-05-06T14:59:27Z
Revision history for this page on the wiki
MediaWiki 1.23.0
https://wiki.twig.es/index.php?title=Importing_photographs_into_a_table,_very_simple&diff=3671&oldid=prev
George2: Created page with "<source lang="sql"> CREATE TABLE ImageTable ( Id int, Name varchar(50) , Photo varbinary(max) ) INSERT INTO ImageTable (Id, Name, Photo) SELECT 1, 'test', BulkColumn F..."
2017-03-13T13:48:45Z
<p>Created page with "<source lang="sql"> CREATE TABLE ImageTable ( Id int, Name varchar(50) , Photo varbinary(max) ) INSERT INTO ImageTable (Id, Name, Photo) SELECT 1, 'test', BulkColumn F..."</p>
<p><b>New page</b></p><div><source lang="sql"><br />
CREATE TABLE ImageTable<br />
(<br />
Id int,<br />
Name varchar(50) ,<br />
Photo varbinary(max)<br />
) <br />
<br />
INSERT INTO ImageTable (Id, Name, Photo)<br />
SELECT 1, 'test', BulkColumn<br />
FROM Openrowset( Bulk 'C:\test.jpg', Single_Blob) as image <br />
<br />
<br />
update ImageTable set photo=<br />
(SELECT BulkColumn <br />
FROM Openrowset( Bulk 'C:\IMSpics14_15\33105810.jpg', Single_Blob) as image)<br />
<br />
<br />
</source></div>
George2