CODEWITHSUNDEEP
sqlinsertopenrowset
Jonathan Yee
Jonathan Yee

Reputation: 1977

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

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.

Upvotes: 1

Views: 7559

Answers (1)

Jonathan Yee
Jonathan Yee

Reputation: 1977

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

Upvotes: 6

Related Questions