SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[savefromfile]
AS
-- original script http://www.databasejournal.com/features/mssql/article.php/3724556/Storing-Images-and-BLOB-files-in-SQL-Server-Part-2.htm
-- modified script http://www.atwork.at/download/savefromfile.txt by Toni Pohl
INSERT INTO MyFiles (FIL_ID, FIL_FileName, FIL_Content)
SELECT 6, '00006_Bild 1.jpg', BulkColumn 
FROM OPENROWSET(Bulk 'D:\Temp\bin\00006_Bild 1.jpg', SINGLE_BLOB) AS BLOB
GO