| title | SET TEXTSIZE (Transact-SQL) | |||||
|---|---|---|---|---|---|---|
| description | Specifies the size, in bytes, of various data types returned to the client by a SELECT statement. | |||||
| author | WilliamDAssafMSFT | |||||
| ms.author | wiassaf | |||||
| ms.reviewer | randolphwest | |||||
| ms.date | 04/17/2025 | |||||
| ms.service | sql | |||||
| ms.subservice | t-sql | |||||
| ms.topic | reference | |||||
| ms.custom |
|
|||||
| f1_keywords |
|
|||||
| helpviewer_keywords |
|
|||||
| dev_langs |
|
|||||
| monikerRange | >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb]
Specifies the size, in bytes, of varchar(max), nvarchar(max), varbinary(max), text, ntext, and image data returned to the client by a SELECT statement.
Important
ntext, text, and image data types will be removed in a future version of [!INCLUDE ssNoVersion]. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
SET TEXTSIZE { number }
The length of varchar(max), nvarchar(max), varbinary(max), text, ntext, or image data, in bytes. number is an integer with a maximum value of 2147483647 (2 GB). A value of -1 indicates unlimited size. A value of 0 resets the size to the default value of 4 KB.
The [!INCLUDE ssNoVersion] Native Client (10.0 and higher) and ODBC Driver for [!INCLUDE ssNoVersion] automatically specify -1 (unlimited) when connecting.
Setting SET TEXTSIZE affects the @@TEXTSIZE function.
The setting of set TEXTSIZE is set at execute or run time and not at parse time.
For more information, see Manage Transact-SQL job steps.
Requires membership in the public role.