Skip to content

Latest commit

 

History

History
31 lines (27 loc) · 1.74 KB

data-at-execution-and-text-ntext-or-image-columns.md

File metadata and controls

31 lines (27 loc) · 1.74 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Data-at-Execution and Text, ntext, Image
Data-at-Execution and Text, ntext, or Image Columns
markingmyname
maghan
03/06/2017
sql
native-client
reference
text columns [ODBC]
SQL Server Native Client ODBC driver, image columns
SQL Server Native Client ODBC driver, text columns
data types [ODBC], image
data types [ODBC], text
columns [ODBC]
ODBC data types, image columns
ODBC data types, text columns
data-at-execution
ODBC data-at-execution
image columns [ODBC]

Data-at-Execution and Text, ntext, or Image Columns

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

ODBC data-at-execution is a feature that enables applications to work with extremely large amounts of data on bound columns or parameters. When retrieving very large text, ntext, or image columns, an application may not be able to simply allocate a huge buffer, bind the column into the buffer, and fetch the row. When updating very large text, ntext, or image columns, the application might not be able to simply allocate a huge buffer, bind it to a parameter marker in a SQL statement, and then execute the statement. In these cases, the application must use SQLGetData or SQLPutData with its data-at-execution options.

See Also

Managing Text and Image Columns