Insert Text Referenced by a Locator

Use sp_drv_text_locator_setdata which accesses the Transact-SQL function setadata.

Syntax

sp_drv_text_locator_setdata locator, offset, new_data_locator, data_length

Input Parameters

  • locator – a text_locator that references the text column to insert into.

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

  • new_data_locator – a text_locator that references the text data to insert.

Output Parameters

data_length – an integer containing the number of characters written.

Result Set

None.

Parent topic: Enabling LOB Locator Support