Using OPENROWSET in an INSERT statement while specifying the values of another column?

Question

I'm using OPENROWSET(BULK ...) to insert the contents of a file into my table. The problem is that I also need to specify the value of another column in the same INSERT statement.

I have something like this:

INSERT INTO MyTable
SELECT *
FROM OPENROWSET(BULK 'c:\foo.bin', SINGLE_BLOB)

I'm sure there's a way to also specify the value of a different column here, but I don't know how.

Jonathan Yee · Accepted Answer · 2009-10-08 19:25:36Z

6

Found it, it was in the link posted by astandar, but under example D:

INSERT INTO MyTable (col1, col2)
SELECT 'foo' AS col1, *
FROM OPENROWSET(BULK N'c:\foo.bin', SINGLE_BLOB) AS col2

answered Oct 8, 2009 at 19:25

Jonathan Yee

1,9972 gold badges20 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Using OPENROWSET in an INSERT statement while specifying the values of another column?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related