Insert file content in `varbinary` column

Question

I need to write a simple SQL script to insert a new line to a table with a varbinary column that is supposed to hold the content of files. I have tried :

DECLARE @FileContent varbinary(max)
SET @FileContent = SELECT * FROM OPENROWSET (BULK 'pathToFile', SINGLE_BLOB);

INSERT INTO [MyTable] ([Name], [Content])
VALUES ('Dummy', @FileContent)

But it does not compile...

Mudassir Hasan · Accepted Answer · 2018-10-24 11:25:07Z

4

Enclose in round brackets SELECT * FROM OPENROWSET

DECLARE @FileContent varbinary(max)
SET @FileContent = (SELECT * FROM OPENROWSET (BULK 'pathToFile', SINGLE_BLOB) tmp);

INSERT INTO [MyTable] ([Name], [Content])
VALUES ('Dummy', @FileContent)

edited Oct 24, 2018 at 11:25

answered Feb 20, 2018 at 13:39

Mudassir Hasan

29k21 gold badges104 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sylvain B. Over a year ago

how, ok, just brackets... Thanks !

Daniel Over a year ago

SET @FileContent = (SELECT * FROM OPENROWSET (BULK 'pathToFile', SINGLE_BLOB) x);

Collectives™ on Stack Overflow

Insert file content in `varbinary` column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related