Determines whether a LOB locator is valid.
locator_valid (locator_descriptor)
is a valid representation of a LOB locator: a host variable, a local variable, or the literal binary value of a locator.
Validates the locator value 0x9067ef4501000000001000000040100400800000000:
locator_valid (0x9067ef4501000000001000000040100400800000000) ------------------- 1
locator_valid returns 1 if the specified locator is valid. Otherwise, it returns 0 (zero).
A locator becomes invalid if invalidated by the deallocate lob command, or at the termination of a transaction.
Any user can execute locator_valid.
Commands deallocate locator, truncate lob
Transact-SQL functions locator_literal, return_lob, create_locator
