Skip to content

Latest commit

 

History

History
62 lines (48 loc) · 3.07 KB

set-textsize-transact-sql.md

File metadata and controls

62 lines (48 loc) · 3.07 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
SET TEXTSIZE (Transact-SQL)
SET TEXTSIZE (Transact-SQL)
WilliamDAssafMSFT
wiassaf
04/12/2016
sql
t-sql
reference
TEXTSIZE_TSQL
TEXTSIZE
SET_TEXTSIZE_TSQL
SET TEXTSIZE
SET TEXTSIZE statement
SELECT statement [SQL Server], text size returned
size [SQL Server], text and image data
TEXTSIZE option
text size returned [SQL Server]
TSQL
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

SET TEXTSIZE (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. 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

Syntax

SET TEXTSIZE { number }

Arguments

number
Is 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 [!INCLUDEssNoVersion] Native Client (10.0 and higher) and ODBC Driver for [!INCLUDEssNoVersion] automatically specify -1 (unlimited) when connecting.

Drivers older than [!INCLUDEssNoVersion] 2008: The [!INCLUDEssNoVersion] Native Client ODBC driver and [!INCLUDEssNoVersion] Native Client OLE DB Provider (version 9) for [!INCLUDEssNoVersion] automatically set TEXTSIZE to 2147483647 when connecting.

Remarks

Setting SET TEXTSIZE affects the @@TEXTSIZE function.

The setting of set TEXTSIZE is set at execute or run time and not at parse time.

Permissions

Requires membership in the public role.

See Also

@@TEXTSIZE (Transact-SQL)
Data Types (Transact-SQL)
SET Statements (Transact-SQL)