Finding Byte Length of Underlying Image Data

Use sp_drv_image_locator_bytelength to find the byte length of a LOB column referenced by an image locator. sp_drv_image_locator_bytelength accesses the Transact-SQL function data_length.

Syntax

sp_drv_image_locator_bytelength locator, data_length

Input Parameters

locator – an image_locator that references the image column to manipulate.

Output Parameters

data_length – an integer specifying the byte length of the image column referenced by locator.

Result Set

None.