SQL Server: Insert an image into a Sql Server table

Platform:SQL Server
Task:Insert an image into a Sql Server table
Discussion:
You need to insert an image into a sql server table
Example:
INSERT INTO BLOBTest(BLOBName,BLOBData) 
SELECT '2010-05-25_739 045.jpg' as BLOBName,* FROM 
OPENROWSET(BULK N'C:\Temp\2010-05-25_739 045.jpg', SINGLE_BLOB) as MyImage
Back to Index