bulk update

Platform: SQL Server 2000 - Hi, I have created database which has million records. Lets a table [table1] which has 100,000 records. Let a key field [field1] has value from 1 to 100,000. I need to change it from 100,001 to 200,000 i.e. 1 to ...

Buenas La siguiente instruccion SQL trabaja bien en SQL 2005: UPDATE [TablaX] SET [ImageX] (SELECT * FROM OPENROWSET(BULK N'C:\Algo\Algo.bin', SINGLE_BLOB) AS StreamFile) WHERE [IDX]00 Pero en SQL 2000 me dice "Error de sintaxis cerca de ...