@@TEXTSIZE (T-SQL)

Returns the current value of the TEXTSIZE option of the SET statement, which specifies the maximum length, in bytes, of text or image data that a SELECT statement returns.

Syntax

@@TEXTSIZE

Return Types

integer

Remarks

The default size is 4096 bytes (4 KB).

Examples

This example uses SELECT to display the @@TEXTSIZE value before and after it is changed with the SET TEXTSIZE statement.

SELECT @@TEXTSIZE

SET TEXTSIZE 2048

SELECT @@TEXTSIZE

Here is the result set:

------------------------

64512