Alternative for the .WRITE function in SQL Server 2000

[GeertVerhoeven]

Hi guys,

I'm currently reading a book (APRESS - ASP.NET 2.0 Unleashed) and found a nice way to upload big files in SQL Server. It uploads the files in chunks of data in case of all at once. The problem is that the sample uses SQL Server 2005.

It uses an update statement with the .WRITE function to append parts of a VARBINARY(MAX) field.

Is there a similar way to do this in SQL 2000?
So what I want is a way of updating a field that can contain files like word files (+/- 10MB) and that can write the contents in chunks of data.

Thanks in advance.

Geert

 

[SQLDenis]

Lookup WRITETEXT in BOL

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[GeertVerhoeven]

Thanks Dennis,

That 's almost what I needed. I think I've overlooked this topic. I'll try the UPDATETEXT because the WRITETEXT will erase all the previous content and I want to edit the text object in chunks (incrementally).

Greetz,

Geert