SQL Server Native Client 功能SQL Server Native Client Features

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

除公开 Windows(以前为 Microsoft)数据访问组件 (WDAC) 的功能以外,SQL ServerSQL Server Native Client 还实现诸多其他功能以公开 SQL ServerSQL Server 功能。In addition to exposing features of the Windows (formerly Microsoft) Data Access Components (WDAC), SQL ServerSQL Server Native Client also implements many other features to expose SQL ServerSQL Server functionality.

本节内容In This Section

处理字符转换时 ODBC 驱动程序行为的变化ODBC Driver Behavior Change When Handling Character Conversions
介绍从 SQL ServerSQL Server 2012 Native Client 开始的行为变化。Discusses a change of behavior beginning in SQL ServerSQL Server 2012 Native Client.

使用数据库镜像Using Database Mirroring
讨论 SQL ServerSQL Server Native Client 如何支持使用镜像数据库,这是在备用服务器上保留数据库的副本或镜像功能 SQL ServerSQL ServerDiscusses how SQL ServerSQL Server Native Client supports the use of mirrored databases, which is the ability to keep a copy, or mirror, of a SQL ServerSQL Server database on a standby server.

执行异步操作Performing Asynchronous Operations
讨论 SQL ServerSQL Server Native Client 如何支持异步操作,即在不阻塞调用线程的情况下立即返回的功能。Discusses how SQL ServerSQL Server Native Client supports asynchronous operations, which is the ability to return immediately without blocking on the calling thread.

使用多个活动的结果集 (MARS)Using Multiple Active Result Sets (MARS)
讨论 SQL ServerSQL Server Native Client 如何支持多个活动结果集 (MARS)。Discusses how SQL ServerSQL Server Native Client supports multiple active result sets (MARS). MARS 支持使用单一数据库连接执行和接收多个结果集。MARS enables you to execute and receive multiple result sets using a single database connection

使用 XML 数据类型Using XML Data Types
讨论 SQL ServerSQL Server Native Client 如何支持 XML 数据类型,此基于 XML 的数据类型可用作列类型、变量类型、参数类型或函数返回类型。Discusses how SQL ServerSQL Server 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
讨论 SQL ServerSQL Server Native Client 如何支持 User-Defined 类型 (UDT) ,它通过允许您在数据库中存储对象和自定义数据结构,从而扩展了 SQL 类型系统 SQL ServerSQL ServerDiscusses how SQL ServerSQL Server 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 SQL ServerSQL Server database.

使用大值类型Using Large Value Types
讨论 SQL ServerSQL Server Native Client 如何支持大值数据类型,该类型是大型对象数据类型 (LOB)。Discusses how SQL ServerSQL Server Native Client supports large value data types, which are large object data types (LOB).

以编程方式更改密码Changing Passwords Programmatically
讨论 SQL ServerSQL Server Native Client 如何支持处理过期密码,现在可以在不需要管理员介入的情况下在客户端更改密码。Discusses how SQL ServerSQL Server 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
讨论 SQL ServerSQL Server Native Client 如何支持对行版本控制的增强功能,该功能通过避免读取器-编写器阻塞情况来提高数据库性能。Discusses how SQL ServerSQL Server Native Client supports the enhancement to row versioning that improves database performance by avoiding reader-writer blocking scenarios.

使用查询通知Working with Query Notifications
讨论 SQL ServerSQL Server Native Client 如何支持基于行集修改的使用者通知。Discusses how SQL ServerSQL Server Native Client supports consumer notification on rowset modification.

执行大容量复制操作Performing Bulk Copy Operations
讨论 SQL ServerSQL Server Native Client 如何支持大容量复制操作,这些操作允许将大量数据传入或传出 SQL ServerSQL Server 表或视图。Discusses how SQL ServerSQL Server Native Client supports bulk copy operations that allow the transfer of large amounts of data into or out of a SQL ServerSQL Server table or view.

使用不带验证的加密Using Encryption Without Validation
讨论如何使用 SQL ServerSQL Server Native Client 对发送到服务器的数据加密,而无需验证证书。Discusses how to use SQL ServerSQL Server Native Client to encrypt data sent to the server without validating the certificate.

表值参数 (SQL Server Native Client)Table-Valued Parameters (SQL Server Native Client)
讨论 SQL ServerSQL Server Native Client 对表值参数的支持。Discusses SQL ServerSQL Server Native Client support for the table-valued parameters.

大型 CLR 用户定义类型Large CLR User-Defined Types
讨论对大型公共语言运行时 (CLR) 用户定义类型 (UDT) 的支持。Discusses support for large common language runtime (CLR) user-defined types (UDTs).

FILESTREAM 支持FILESTREAM Support
讨论 SQL ServerSQL Server Native Client 对增强型 FILESTREAM 功能的支持。Discusses SQL ServerSQL Server Native Client support for the enhanced FILESTREAM feature.

客户端连接中的服务主体名称 (SPN) 支持Service Principal Name (SPN) Support in Client Connections
讨论如何扩展对服务主体名称 (SPN) 的支持,以便能够跨所有协议进行相互身份验证。Discusses how support for service principal names (SPNs) has been extended to enable mutual authentication across all protocols.

SQL Server Native Client 中的稀疏列支持Sparse Columns Support in SQL Server Native Client
讨论 SQL ServerSQL Server Native Client 对稀疏列的支持。Discusses SQL ServerSQL Server Native Client support for sparse columns.

日期和时间改进Date and Time Improvements
讨论 SQL ServerSQL Server Native Client 中添加的对日期和时间数据类型的支持。Discusses support added to SQL ServerSQL Server Native Client for the date and time data types.

元数据发现Metadata Discovery
讨论对 SQL Server 2012 (11.x)SQL Server 2012 (11.x) 中的元数据发现功能进行的改进。Discusses metadata discovery improvements that were made in SQL Server 2012 (11.x)SQL Server 2012 (11.x).

SQL Server Native Client 11.0 中的 UTF-16 支持UTF-16 Support in SQL Server Native Client 11.0
讨论 SQL Server 2012 (11.x)SQL Server 2012 (11.x) 中引入的行为更改。Discusses a behavior change introduced in SQL Server 2012 (11.x)SQL Server 2012 (11.x). 如果在绑定列结果或输出参数时提供固定长度的缓冲区,并且在终止字符之前写入缓冲区中的 wchar 字符是代理项对的高代理项码位,并且下一个 wchar 字符是低代理项码位,则 SQL ServerSQL Server Native Client 将不会向缓冲区添加高代理项码位。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, SQL ServerSQL Server Native Client will not add the high surrogate code point to the buffer.

对高可用性、灾难恢复的 SQL Server Native Client 支持SQL Server Native Client Support for High Availability, Disaster Recovery
讨论如何配置应用程序以利用 SQL Server 2012 (11.x)SQL Server 2012 (11.x) 中添加的高可用性和灾难恢复功能。Discusses how your application can be configured to take advantage of the high-availability, disaster recovery features added in SQL Server 2012 (11.x)SQL Server 2012 (11.x).

访问扩展事件日志中的诊断信息Accessing Diagnostic Information in the Extended Events Log
讨论对于 SQL ServerSQL Server Native Client 和跟踪数据的增强功能,它们使您可以访问环形缓冲区和 XEvents 日志中的诊断信息。Discusses enhancements to SQL ServerSQL Server Native Client and data tracing that gives you access to diagnostic information in the ring buffer and XEvents log.

SQL Server Native Client 对 LocalDB 的支持SQL Server Native Client Support for LocalDB
讨论 SQL ServerSQL Server Native Client 对 LocalDB 功能的支持。Discusses SQL ServerSQL Server Native Client support for the LocalDB feature.

另请参阅See Also

SQL Server Native Client 编程 SQL Server Native Client Programming
ODBC 操作指南主题 ODBC How-to Topics
OLE DB 操作指南主题 OLE DB How-to Topics
安装 SQL Server Native ClientInstalling SQL Server Native Client