How can I insert binary file data into a binary SQL field using a simple insert statement?
I believe this would be somewhere close. INSERT INTO Files (FileId, FileData) SELECT 1, * FROM OPENROWSET(BULK N’C:\Image.jpg’, SINGLE_BLOB) rs Something to note, the above runs in SQL Server 2005 and SQL Server 2008 with the data type as varbinary(max). It was not tested with image as data type.