| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Features |
In addition to exposing features of the Windows Data Access Components, SQL Server Native Client implements other features to expose SQL Server functionality. |
markingmyname |
maghan |
03/17/2017 |
sql |
native-client |
reference |
|
[!INCLUDE SQL Server]
Important
[!INCLUDEsnac-removed-oledb-and-odbc]
In addition to exposing features of the Windows (formerly Microsoft) Data Access Components (WDAC), [!INCLUDEssNoVersion] Native Client also implements many other features to expose [!INCLUDEssNoVersion] functionality.
ODBC Driver Behavior Change When Handling Character Conversions
Discusses a change of behavior beginning in [!INCLUDEssNoVersion] 2012 Native Client.
Using Database Mirroring
Discusses how [!INCLUDEssNoVersion] Native Client supports the use of mirrored databases, which is the ability to keep a copy, or mirror, of a [!INCLUDEssNoVersion] database on a standby server.
Performing Asynchronous Operations
Discusses how [!INCLUDEssNoVersion] Native Client supports asynchronous operations, which is the ability to return immediately without blocking on the calling thread.
Using Multiple Active Result Sets (MARS)
Discusses how [!INCLUDEssNoVersion] Native Client supports multiple active result sets (MARS). MARS enables you to execute and receive multiple result sets using a single database connection
Using XML Data Types
Discusses how [!INCLUDEssNoVersion] Native Client supports the XML data type, which is a XML-based data type that can be used as a column type, variable type, parameter type, or function return type.
Using User-Defined Types
Discusses how [!INCLUDEssNoVersion] Native Client supports User-Defined Types (UDT), which extends the SQL type system by allowing you to store objects and custom data structures in a [!INCLUDEssNoVersion] database.
Using Large Value Types
Discusses how [!INCLUDEssNoVersion] Native Client supports large value data types, which are large object data types (LOB).
Changing Passwords Programmatically
Discusses how [!INCLUDEssNoVersion] Native Client supports the handling of expired passwords so that passwords can now be changed on the client without administrator involvement.
Working with Snapshot Isolation
Discusses how [!INCLUDEssNoVersion] Native Client supports the enhancement to row versioning that improves database performance by avoiding reader-writer blocking scenarios.
Working with Query Notifications
Discusses how [!INCLUDEssNoVersion] Native Client supports consumer notification on rowset modification.
Performing Bulk Copy Operations
Discusses how [!INCLUDEssNoVersion] Native Client supports bulk copy operations that allow the transfer of large amounts of data into or out of a [!INCLUDEssNoVersion] table or view.
Using Encryption Without Validation
Discusses how to use [!INCLUDEssNoVersion] Native Client to encrypt data sent to the server without validating the certificate.
Table-Valued Parameters (SQL Server Native Client)
Discusses [!INCLUDEssNoVersion] Native Client support for the table-valued parameters.
Large CLR User-Defined Types
Discusses support for large common language runtime (CLR) user-defined types (UDTs).
FILESTREAM Support
Discusses [!INCLUDEssNoVersion] Native Client support for the enhanced FILESTREAM feature.
Service Principal Name (SPN) Support in Client Connections
Discusses how support for service principal names (SPNs) has been extended to enable mutual authentication across all protocols.
Sparse Columns Support in SQL Server Native Client
Discusses [!INCLUDEssNoVersion] Native Client support for sparse columns.
Date and Time Improvements
Discusses support added to [!INCLUDEssNoVersion] Native Client for the date and time data types.
Metadata Discovery
Discusses metadata discovery improvements that were made in [!INCLUDEssSQL11].
UTF-16 Support in SQL Server Native Client 11.0
Discusses a behavior change introduced in [!INCLUDEssSQL11]. If you supply a fixed-length buffer when binding a column result or output parameter and if the wchar character written into the buffer before the terminating character is a high surrogate code point of a surrogate pair, and if the next wchar character is a low surrogate code point, [!INCLUDEssNoVersion] Native Client will not add the high surrogate code point to the buffer.
SQL Server Native Client Support for High Availability, Disaster Recovery
Discusses how your application can be configured to take advantage of the high-availability, disaster recovery features added in [!INCLUDEssSQL11].
Accessing Diagnostic Information in the Extended Events Log
Discusses enhancements to [!INCLUDEssNoVersion] Native Client and data tracing that gives you access to diagnostic information in the ring buffer and XEvents log.
SQL Server Native Client Support for LocalDB
Discusses [!INCLUDEssNoVersion] Native Client support for the LocalDB feature.
SQL Server Native Client Programming
ODBC How-to Topics
OLE DB How-to Topics
Installing SQL Server Native Client