Insert images with TSQL query from filesystem to a Microsoft SQL Server 2008 database

3 August, 2009 Roel van Lisdonk 0 Comments 0 categories

To insert a image from filesystem to a Microsoft SQL Server 2008 database with a TSQL query, use:

INSERT INTO MyTable(MyImageColumn)
SELECT * FROM
OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB)

If you change your database name and then open LLBLGen…

If you want the double quotes to appear when you…

/// <summary> /// Convert a byte array to a hex…