Can I append to a BLOB in MSSQL database from C# without reading the original data?

Question

Hi,

I'd like to be able to append some data to a binary field in a MS SQL 2005 server from C# without reading the original data, concatenating it, and then setting it all back.

Is this possible?

Cheers! Steve

Answer 1

Well, I don't know for a BLOB, but for text you can do this:

UPDATE tablename SET columnname=concat(columnname,' my extra text');

Answer 2

Read about the UPDATETEXT sql statement at http://msdn.microsoft.com/en-us/library/3517w44b.aspx. The Msdn article contains example code that appends binary data to a blob in the StorePhoto method.