Skip to content

set-textsize-transact-sql.md

Latest commit

 

History

History
66 lines (51 loc) · 3.39 KB

set-textsize-transact-sql.md

File metadata and controls

66 lines (51 loc) · 3.39 KB
title SET TEXTSIZE (Transact-SQL)
description SET TEXTSIZE (Transact-SQL)
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 04/12/2016
ms.prod sql
ms.prod_service database-engine, sql-database, synapse-analytics, pdw
ms.technology t-sql
ms.topic reference
f1_keywords
TEXTSIZE_TSQL
TEXTSIZE
SET_TEXTSIZE_TSQL
SET TEXTSIZE
helpviewer_keywords
SET TEXTSIZE statement
SELECT statement [SQL Server], text size returned
size [SQL Server], text and image data
TEXTSIZE option
text size returned [SQL Server]
dev_langs
TSQL
ms.assetid 787154a6-39a6-4dd6-a6d0-67b4364f95d5
monikerRange >=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.

Topic link icon Transact-SQL Syntax Conventions

Syntax

SET TEXTSIZE { number }

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)