Inserting Unitext at Specified Position

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

Syntax

sp_drv_unitext_setdata locator, offset, new_data, data_length

Input Parameters

  • locator –a unitext_locator that references the unitext column to insert into.

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

  • new_data – univarchar or unitext data to insert.

Output Parameters

data_length – an integer containing the number of characters written.

Result Set

None.

Parent topic: Adaptive Server Enterprise ODBC Driver Support