Insert Image Referenced by a Locator

Use sp_drv_image_locator_setdata which accesses the Transact-SQL function setadata.

Syntax

sp_drv_image_locator_setdata locator, offset, new_data_locator,
   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_locator – an image_locator that references the image data to insert.

Output Parameters

data_length – an integer containing the number of bytes written.

Result Set

None.

Parent topic: Enabling LOB Locator Support