Insert image binary data into table using values keyword

Question

create table Item(
    ID int identity(1000,1) not null,
    txt varchar(150),
    img varbinary(max),
    constraint pk_Item primary key (ID)
)

I can insert an image into this table using the following query:

insert into Item(ID,txt,img) 
select 100,'test', BulkColumn from openrowset(bulk N'D:\test.jpeg', single_blob) as image

How can I achieve the same using the values keyword:

insert into Item(ID,txt,img) values (100,'test',[????])

Pரதீப் · Accepted Answer · 2017-01-05 01:09:04Z

3

Not sure why you want to insert with values keyword when you already have alternative. Try this

insert into Item(ID,txt,img) 
values (100,'test',(select BulkColumn from openrowset(bulk N'D:\test.jpeg', single_blob) cs))

answered Jan 5, 2017 at 1:09

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

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

Comments

user3112728 · Accepted Answer · 2017-01-05 02:58:20Z

0

Binary values have a 0x{hexdecimal byte sequence} prefix.

insert into Item(ID,txt,img) 
values (100,'test',0x0123456789ABCDEF)

It might be helpful to just query a field that already has binary value to see what it looks like:

select img from Item

answered Jan 5, 2017 at 2:58

user3112728

4052 silver badges13 bronze badges