【正文】 模塊訪問驅(qū)動程序中別實現(xiàn)的。（４）遠程存儲過程遠程存儲過程是從連接到不同服務(wù)器的遠程服務(wù)器或客戶機調(diào)用的存儲過程。應(yīng)用后的應(yīng)用程序管理。數(shù)據(jù)庫應(yīng)用程序的性質(zhì)和復(fù)雜性，以及計劃數(shù)據(jù)庫的過程，它們之間的差異是非常大的。N層 處理在數(shù)據(jù)庫服務(wù)器、應(yīng)用程序服務(wù)器和客戶機之間劃分。 體系結(jié)構(gòu)設(shè)計典型的應(yīng)用程序部署選項包括：智能服務(wù)器（兩層） 大多數(shù)的處理發(fā)生在服務(wù)器上，而表示服務(wù)在客戶機上處理。ADO可以從Microsoft Visual Basic, Visual Basic for Applications, Active Server Pages(ASP)和Microsoft Internet Explorer腳本對象模型中使用。SQL Server提供對兩大類數(shù)據(jù)庫API的固有支持，而這些API有確定可以使用的數(shù)據(jù)對象接口。SQL Server支持這樣的一些網(wǎng)絡(luò)協(xié)議：TCP/IP，命名管道，NOVELL IPX/SPX，BANYAN VINES/IP和APPLETALK ADSP。tables can be modified only by stored procedures. This means that potentiallystring on the fly, as in the example shown above? Well, there are several reasons: A stored procedure is piled by the database. This produces an execution global temporary stored procedures are available for all user sessions.Remote Stored Procedures Remote stored procedures are a legacy feature of SQL Server environment. Extended stored procedures are typically identified by the xp_prefix. They are executed in a manner similar to that of stored procedures.6. ODBC PurposeThe Microsoft Open Database Connectivity (ODBC) interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). The ODBC interface permits maximum interoperability—an application can access data in diverse DBMSs through a single interface. Furthermore, that application will be independent of any DBMS from which it accesses data. Users of the application can add software ponents called drivers, which interface between an application and a specific DBMS.Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the CallLevel Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.ODBC is designed for maximum interoperability—that is, the ability of a single application to access different database management systems (DBMSs) with the same source code. Database applications call functions in the ODBC interface, which are implemented in databasespecific modules called drivers. The use of drivers isolates applications from databasespecific calls in the same way that printer drivers isolate word processing programs from printerspecific mands. Because drivers are loaded at run time, a user only has to add a new driver to access a new DBMS。Designing the database so that your application use hardware optimally and allows for future grows, identifying and modeling database objects and application logic, and specifying the types of information for each object and type of relationship.t have parameters, then it really doesn39。execution of the procedure faster. Stored procedures are often cached by the database, thus making them fasterboth a recordset and other values. As a general rule, stored procedures will nearly always開放數(shù)據(jù)服務(wù) 這是一個SQL Server組件，處理網(wǎng)絡(luò)連接，把客戶的請求傳給SQL Server進行處理，并把任何結(jié)果和應(yīng)答返回給SQL Server客戶。OLE DB可以訪問SQL Server，其他關(guān)系數(shù)據(jù)庫和其他數(shù)據(jù)源中的數(shù)據(jù)。在設(shè)計一個SQL Server應(yīng)用程序之前，花一些時間設(shè)計一個數(shù)據(jù)庫對業(yè)務(wù)對象準(zhǔn)確建模是很重要的。但是，服務(wù)器會變成一個瓶頸，因為數(shù)據(jù)庫和業(yè)務(wù)服務(wù)競爭相同的硬件資源。多層企業(yè)應(yīng)用程序和使用事務(wù)處理監(jiān)視程序開發(fā)的應(yīng)用程序是這種設(shè)計的一個例子。設(shè)計數(shù)據(jù)庫。正確的數(shù)據(jù)庫設(shè)計、索引的的正確使用、RAID和文件組，它們的組合對于獲得好的性能是必需的。存儲過程是SQL語句的命名集合，存放在服務(wù)器上。 進而，請求將不依賴于它從其中訪問數(shù)據(jù)的任何DBMS。Command對象特定地為處理各種類型的命令而設(shè)計，特別是那些需要參數(shù)的命令。并非所有的數(shù)據(jù)庫都支持這種緩存機制，比如微軟的Access 就不支持，而SQL Server卻支持。