外文翻譯-sqlserver體系結(jié)構(gòu)-免費(fèi)閱讀
【正文】 ? 可以將所有SQL代碼集中存放于服務(wù)器。存儲過程(有時也稱存儲查詢)是存儲在數(shù)據(jù)庫中預(yù)先定義的SQL查詢語句。ODBC被設(shè)計(jì)用于能允許使用相同源代碼通過單一請求訪問不同數(shù)據(jù)庫管理系統(tǒng)的最大限度聯(lián)機(jī)操作。（3）臨時存儲過程臨時存儲過程可以是局部的，名字前有一個磅符（＃），也可以是全局的，名字前有兩個磅符（＃＃）；局部臨時存儲過程在單個用戶會話中可用，全局臨時存儲過程在所有會話中都可用。包括表、數(shù)據(jù)庫完整性機(jī)制、數(shù)據(jù)輸入和獲取對象（常常是存儲過程）、合適的索引、和安全策略。 Server數(shù)據(jù)庫實(shí)現(xiàn)一個SQL Server數(shù)據(jù)庫意味著計(jì)劃，創(chuàng)建和維護(hù)一些相互關(guān)聯(lián)的組件。使用Microsoft Access這樣的產(chǎn)品為小單位開發(fā)的應(yīng)用程序是這種設(shè)計(jì)的一個例子?？梢园衍浖?yīng)用程序分為3個邏輯層，他們可以位于一個或多個服務(wù)器上。ActiveX數(shù)據(jù)對象（ADO） ActiveX數(shù)據(jù)對象（ADO）在一個簡化的數(shù)據(jù)模型中封裝OLE DB API，降低了應(yīng)用程序開發(fā)和維護(hù)的成本。 應(yīng)用程序編程接口數(shù)據(jù)庫API定義如何寫一個應(yīng)用程序連接到數(shù)據(jù)庫，和把命令傳遞給數(shù)據(jù)庫。通信體系結(jié)構(gòu)中的組件包括：應(yīng)用程序、數(shù)據(jù)庫接、網(wǎng)絡(luò)庫、 客戶機(jī)和服務(wù)器可以同時使用多個NetLibrary，但是為了成功通信，它們必須使用一個公共的網(wǎng)絡(luò)庫。t, but SQL Server does. You can make your data a little bit more secure by specifying that your database So why should we create and use a stored procedure instead of just creating a SQLAdministering the application after deployment, which includes configuring servers and clients, monitoring server performance, managing jobs, alerts, and operators, managing security, and managing database backup procedures. Procedures to Stored ProceduresThis section introduces the different types of stored procedures, describes how stored procedures are processed, both initially and on subsequent execution, and lists some of the advantages of using stored procedures. Stored ProceduresA stored procedure is a named collection of TransactSQL statements that is stored on the server. Stored procedures are a method of encapsulating repetitive tasks that executes efficiently. Stored procedures support userdeclared variables, conditional execution, and other powerful programming features. Microsoft SQL Server version supports five types of stored procedures:System Stored Procedures (sp_) Stored in the master database, system stores procedures (identified by type sp_prefix) provide an effective method to retrieve information from system tables. They allow system administration tasks that update system tables even though the administrators do not have permission to update the underlying tables directly. System stored procedures can be executed in any database.Local Stored Procedures Local stored procedures are created in individual user databases.Temporary Stored Procedures Temporary stored procedures can be local, with names that start with a double pound symbol () ——local temporary stored procedures are available within a single user session。Creating the database and database objects, including tables, data integrity mechanisms, data entry and retrieval object(often stored procedure), appropriate indexes, and security.t matter whether you use a Connection, a Command, or a Recordset. ProceduresThe use of stored procedures is the one area where the Command object es intoto run, as they don39。be quicker than their equivalent SQL statements. To use a stored procedure you just put the name of the stored procedure as the mand開放數(shù)據(jù)服務(wù)自動監(jiān)聽在服務(wù)器上安裝的所有服務(wù)器網(wǎng)絡(luò)庫。ODBC 這是一個調(diào)用級的接口，它直接訪問SQL Server TDS協(xié)議，并支持使用ODBC的數(shù)據(jù)對象接口寫的應(yīng)用程序或組件。一個很好設(shè)計(jì)的數(shù)據(jù)庫要求極少的更改通常更有效的執(zhí)行。以數(shù)據(jù)庫為中心的視點(diǎn)設(shè)計(jì)的團(tuán)體應(yīng)用程序是這種設(shè)計(jì)的一個例子。Internet 處理分為3層，業(yè)務(wù)和表示服務(wù)位于Web服務(wù)器上，客戶機(jī)使用簡單的瀏覽器。使得應(yīng)用程序最優(yōu)化的使用硬件，并允許未來的擴(kuò)展；標(biāo)識和建模數(shù)據(jù)庫對象和應(yīng)用程序邏輯，規(guī)定每個對象的信息類型和關(guān)系的類型。存儲過程是包裝重復(fù)任務(wù)有效執(zhí)行的一種方式，支持用戶聲明的變量，條件執(zhí)行和其他強(qiáng)功能的程序設(shè)計(jì)特性。 應(yīng)用程序的用戶能增加請求驅(qū)動程序的軟件組成部分，此驅(qū)動程序是請求和具體的DBMS之間的接口。與Connection對象相似， Command對象可以運(yùn)行返回記錄集和不返回記錄集兩種類型的命令。? 通過指定數(shù)據(jù)庫中的表只能被存儲過程修改，可以確保數(shù)據(jù)更安全。為了使用存儲過程，只要將存儲過程的名字作為命令文本，并設(shè)置相應(yīng)的類型。? 存儲過程通常被數(shù)據(jù)庫高速緩存，這樣使它們運(yùn)行得更快，因?yàn)榇藭r不需從磁盤中讀取它們。 因?yàn)轵?qū)
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1