Declaring a LOB Datatype

Use the declare function to declare an LOB datatype for a local variable.

declare @variable LOB_datatype

Example 1

This example declares the text_variable as text datatype:
declare @text_variable text
Parent topic: Using Large Object text, unitext, and image Datatypes in Stored Procedures