Server global variables for text and image updates

Adaptive Server and SQL Server version 11.0 and later have global variables specifically for text and image support. These variables are:

Variable

Explanation

Datatype

@@textptr

The text pointer of the last text or image column inserted or updated by a process.

binary(16)

@@textts

Text timestamp of the column referenced by @@textptr.

varbinary(8)

@@textcolid

ID of the column referenced by @@textptr.

tinyint

@@textdbid

ID of the database containing the object with the column referenced by @@textptr.

smallint

@@textobjid

ID of the object containing the column referenced by @@textptr.

int

Each connection to Adaptive Server has its own instance of these variables. The variables are set at 0 at the beginning of a session. Adaptive Server updates the variables: