| title | Data-at-Execution and Text, ntext, Image | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| description | Data-at-Execution and Text, ntext, or Image Columns | |||||||||||
| author | markingmyname | |||||||||||
| ms.author | maghan | |||||||||||
| ms.date | 03/06/2017 | |||||||||||
| ms.service | sql | |||||||||||
| ms.subservice | native-client | |||||||||||
| ms.topic | reference | |||||||||||
| helpviewer_keywords |
|
[!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.