Thursday, November 25, 2010

Inserting a file into filestream column using OPENROWSET SQL function

INSERT INTO [tblFile]([file] ,[RowGuid])

SELECT CONVERT(varbinary(max) , Document.bulkcolumn), NEWID()
FROM OPENROWSET(BULK N'\\FilePath\File' ,SINGLE_BLOB) AS Document