SQL Server Native Client 功能SQL Server Native Client Features

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure 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 DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure 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) Data Access Components (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.

使用 Multiple Active Result Set (MARS)Using Multiple Active Result Sets (MARS)
討論 SQL ServerSQL Server Native Client 如何支援 Multiple Active Result Set (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 如何支援 (UDT) 的 User-Defined 型別,這可讓您將物件和自訂資料結構儲存在資料庫中,藉此擴充 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
討論大型 Common Language Runtime (CLR) 使用者定義型別 (UDT) 的支援。Discusses support for large common language runtime (CLR) user-defined types (UDTs).

FILESTREAM 支援FILESTREAM Support
討論 SQL ServerSQL Server 增強型 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
討論可讓您存取信號緩衝區和 XEvents 記錄檔中之診斷資訊的 SQL ServerSQL Server Native Client 及資料追蹤增強功能。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