Data Types (OLE DB)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Download OLE DB driver

In order to execute Transact-SQL statements and process the results using the OLE DB Driver for SQL Server, you must know how the OLE DB Driver for SQL Server maps SQL Server data types to OLE DB data types when binding parameters or columns in a rowset, and when it uses the ITableDefinition interface to create a table in SQL Server.

In This Section

• Data Type Mapping in Rowsets and Parameters

• Data Type Mapping in ITableDefinition

• SSVARIANT Structure

See Also

OLE DB Driver for SQL Server Programming