Export (0) Print
Expand All
Expand Minimize

@@TEXTSIZE (Transact-SQL)

Windows Server 2003

Returns the current value of the TEXTSIZE option of the SET statement. This specifies the maximum length, in bytes, of varchar(max), nvarchar(max), varbinary(max), text, or image data that a SELECT statement returns.

Topic link icon Transact-SQL Syntax Conventions


@@TEXTSIZE

integer

The default size is 4096 bytes. The maximum size that @@TEXTSIZE returns is 2^31-1 bytes.

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

SELECT @@TEXTSIZE AS 'Text Size'
SET TEXTSIZE 2048
SELECT @@TEXTSIZE AS 'Text Size'

Here is the result set.

Text Size  
-----------
4096       

Text Size  
-----------
2048       

Community Additions

ADD
Show:
© 2014 Microsoft