@@TEXTSIZE

Transact-SQL Reference

Transact-SQL Reference

@@TEXTSIZE

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.

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

------------------------
2048

See Also

Configuration Functions

SET TEXTSIZE