Append binary using update in sql server

Question

I have binary data in specific field in sql server 2008, but i want to append some binary data to the same field. can you help me about that?

varbinary(max) or image ? it matters

Marc Gravell
– Marc Gravell

2012-11-19 08:04:47 +00:00
Commented Nov 19, 2012 at 8:04 — Marc Gravell
– Marc Gravell, Commented Nov 19, 2012 at 8:04

Marc Gravell · Accepted Answer · 2012-11-19 08:11:09Z

8

If it is a varbinary(n) / varbinary(max) - you just append with +:

declare @foo table(id int, bar varbinary(max))

insert @foo values(1, 0x01)

declare @newdata varbinary(max) = 0x020304

update @foo set bar = bar + @newdata
where id = 1

select bar from @foo
where id = 1

If you are using image, you can use UPDATETEXT, but it is more involved (read MSDN) - insert_offset of NULL means "append", and specify delete_length of 0.

answered Nov 19, 2012 at 8:11

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

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

Collectives™ on Stack Overflow

Append binary using update in sql server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related