3 August, 2009
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)
Tags: SQL ServerT-SQL