To declare an LOB datatype for a local variable, use:
declare @variable LOB_datatype
where LOB_datatype is one of: text, image, and unitext.
This example declares the text_variable as text datatype:
declare @text_variable text
