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

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)