【正文】 SQL the Server data sheet is: Wages situation. 4) Operating procedure then. (2) opens the longdistance database with the RDO method 1) In local ODBC UserDSN establishment and SQL SERVER connection data pool. Needs to suppose: Data Source Name: Data source name, Descrption: Description, Server:SQL Server server, D atabase Name: Database. (This kind of establishment may suppose under single plane condition) . 2) increases in the procedure… Pr Set 中原工學(xué)院 信息商務(wù)學(xué)院 畢業(yè)設(shè)計（ 論文 ）專用紙 第 16 頁 mrdoconn=(″pms″,rdDriverNoPrompt,False,″ODBC。 Then singleclicks Options the button, fence chooses SQL in Options in the frame Database which wants to land Server database. Then singleclicks OK the button. Isual Basic is a function formidable visible programming tool which Microsoft promotes. It relies on with the ODBC good connection and provides to the user the extremely perfect work database visit controls, wins domestic and foreign 中原工學(xué)院 信息商務(wù)學(xué)院 畢業(yè)設(shè)計（ 論文 ）專用紙 第 15 頁 multitudinously programs amateur39。 Inputs the description information in Description (to be possible to elect)。 Size (MB): Uses in to establish this equipment the size (generally for database times). Singleclicks Create the Now button, founds this equipment. Attention: Please in front of foundation database must first found two storage devices, is the database physical equipment, another is the database logical equipment. 2. on founds a database in SQL SERVER (1) procedure group to open SQL EM from Microsoft SQL Server in Utilties. (2) in Server in Manager window, choice foundation database server. . (3) chooses the Manage vegetable single item, then chooses the Database option. Appears Manage the Database window. (4) chooses New the Database button (first). Appears New the Database window. (5) the Name item for database, Data Device is the database physics equipment name, Size is this physical equipment for the database assignment storage space (MB)。 Also has the prominent performance in the low construction cost platform。PWD=355″) 中原工學(xué)院 信息商務(wù)學(xué)院 畢業(yè)設(shè)計（ 論文 ）專用紙 第 9 頁 ssql=″select*from 工資情況 Set mrdors=(ssql,rdOpenKeyset,rdConcurRowVer,0) 出處： 專家系 統(tǒng)與應(yīng)用 , 37 卷 , 9 月份發(fā)行 9 到 2020 年 ,頁 64826492 英文原文 ： Source:Expert Systems with Applications Volume 37. Issue 9. September 2020. Pages 64826492 Development based on SQL SERVER C/S database application system SQL the Server achievement face the small and mediumsized enterprise the work database service system, has provided with the multitudinous highlevel data bank administration same performance characteristic, initiated the powerful challenge to the traditional database merchant. In programming aspect: SQL Server has used the key but the novel symmetrical expression structure, thus simplified the programming, and Microsoft visible programming language provided good in its Visual in the Basic for the programmer has controlled。 (2) 用 RDO 方法打開遠(yuǎn)程數(shù)據(jù)庫 ① 在本地 ODBC 的 UserDSN 中設(shè)置與 SQL SERVER 連接的數(shù) 據(jù)源。 中原工學(xué)院 信息商務(wù)學(xué)院 畢業(yè)設(shè)計（ 論文 ）專用紙 第 8 頁 Dim ssql As String =″ODBC。 9. 以下采用編程常用的 DAO 和 RDO 兩種方法，為大家介紹 一下怎樣使用 Visual Basic 訪問遠(yuǎn)程 SQL Server 數(shù)據(jù)庫 (1) 用 DAO 方法打開遠(yuǎn)程數(shù)據(jù)庫 ① 在本地 ODBC 的 FileDSN 中設(shè)置與 SQL SERVER 連接的數(shù)據(jù)源。然后單擊 “ OK” 按鈕。 (2) 對于 File DSN 的調(diào)試 ① 在系統(tǒng)的 “ 開始 ” 菜單上選擇 “ 設(shè)置 ” ，單擊其中的 “ 控制面板 ” ，彈出控制面板框。 ② 雙擊 “ 32bit ODBC” 圖標(biāo)，彈出 “ ODBC data source administrator”窗口，選擇 “ USE R DSN” 頁，單擊 “ Add...” 按鈕。 中原工學(xué)院 信息商務(wù)學(xué)院 畢業(yè)設(shè)計（ 論文 ）專用紙 第 6 頁 ODBC（開放數(shù)據(jù)庫連接）是 Microsoft 為應(yīng)用程序開發(fā)人員提供的一種策略。 (5) 最后單擊 “ Set” 按鈕，保存設(shè)置。 7. 在 SQL Server 中為數(shù)據(jù)庫用戶設(shè)置訪問權(quán)限 (1) 對于新開的數(shù)據(jù)庫一定要為訪問它的用戶提供權(quán)限，否則這個數(shù)據(jù)庫是不能被訪問的。 (2) 選擇 login 目錄，單擊右鍵，選擇 New Login...，彈出 Manage Logins 窗口。 (5) 在 Index Attribute (索引屬性 )窗框內(nèi)，選 擇 Clustered (群集 )復(fù)選框。在里面輸入新索引的名字。 5. 為表格創(chuàng)建群集索引 (1) 啟動 SQL EM,選擇 相應(yīng)的數(shù)據(jù)庫。 (6) 對于主關(guān)鍵字來說，索引類型應(yīng)定義為 （ nonclustered） 。 (5) 在第一張卡片 （ Primary Key/Iden