Inserting an Image at Specified Position

Use sp_drv_image_setdata, which accesses the Transact-SQL function setadata.

Syntax

sp_drv_image_setdata locator, offset, new_data, datalength

Input Parameters

  • locator – an image_locator that references the image column to insert in.

  • offset – an integer specifying the position from which to start writing the new content.

  • new_data – varbinary or image data to insert.

Output Parameters

data_length – an integer containing the number of bytes written.

Result Set

None.

Parent topic: Adaptive Server Enterprise ODBC Driver Support