【正文】 time of password. 7. in SQL Server for database user establishment visit jurisdiction (1) certainly must for visit its user in SQL Server for the database user establishment visit jurisdiction regarding the newly opened database to provide the jurisdiction, otherwise this database is cannot visit. (2) starts Microsoft SQL Server EM, chooses the suitable server as well as the database. (3) chooses Object from the Object menu the Permission vegetable single item, again in springs in the dialog box listed has singleclicked By Us the label. (4) must want to award a user or the user group specific jurisdiction, so long as pulls the type from User/Group to tabulate designated the user or the user group, and singleclicks the corresponding jurisdiction the unit standard. (5) finally singleclicks Set the button, preserves the establishment. Moreover, SQL Server has also provided the function formidable backup for the system manager and restores the database function. But, wants to visit SQL Server from the work client only to suppose the server side not to be good. Carries on the programming using Visual Basic to SQL Ser ver also to need to carry on the establishment to customer end ODBC. ODBC (opening database connection) is Microsoft is one kind of strategy which the application procedure development personnel provides. It uses sole API to radiate each kind of different database engine, relational and non relational DBMS (database management system). It causes the database development personnel at development database application system time, may use familiar ODBC the SQL grammar, but does not use the consideration data pool is any. 8. Below is the customer carries ODBC the establishment and the debugging method (1) regarding the USER DSN establishment 1) The start in the menu chooses the establishment in the system, singleclicks the control panel, springs the control panel frame. 2) doubleclicks 32bit ODBC the chart sign, springs ODBC data source administrator the window, the choice USE R DSN the page, singleclicks Add... Button. 3) in the window chooses SQL SERVER after Create New Data Source, singleclicks pletes the button, springs ODBC SQL SERVER Setup the window. 4) inputs data source name in Data Source Name, like pms。 Location: May choose founds the equipment the place (for example: C: \ databas e)。 With Windows the NT integration, allows in SMP (symmetrical multiprocessing) in the system to carry on the thorough multithreading and the symmetrical multiprocessing, and may integrate in the distributional management environment。UID=te st。pwd=355″ ssql=″select*from 工資情況 =ssql ④ 運(yùn)行程序即可。用戶名為： test；用戶口令為： 355； SQL Server 數(shù)據(jù)表為：工資情況。 有了 Visual Basic 我們可以利用它的 ODBC 接口在幾分鐘內(nèi)編制一個(gè)基于 SQL Server 的客戶機(jī) /服務(wù)器數(shù)據(jù)庫(kù)應(yīng)用軟件。 ④ 在彈出的 SQL Server Login 對(duì)話框中：在 “ Server” 欄中輸入 SQL Server 服務(wù)器名；在 “ Login ID” 欄和 “ Password” 欄中輸入登陸 SQL Server時(shí)用的用戶名和用戶口令；然后單 擊 “ Options” 按鈕，在 Options 框中的Database 欄中選擇所想登陸的 SQL Server 數(shù)據(jù)庫(kù)名 。 ⑤ 單擊 “ 確定 ” 按鈕。 8. 以下是客戶端 ODBC 的設(shè)置和調(diào)試方法 (1) 對(duì)于 USER DSN 的設(shè)置 ① 在系統(tǒng)的 “ 開始 ” 菜單上選擇 “ 設(shè)置 ” ，單擊其中的 “ 控制面板 ” ，彈出控制面板框。利用Visual Basic 對(duì) SQL Ser ver 進(jìn)行編程還需要對(duì)客戶端的 ODBC 進(jìn)行設(shè)置。 (4) 要想授予一個(gè)用戶或用戶組特定的權(quán)限，只要從 User/Group 下拉式列表中選定用戶或用 戶組，并單擊相應(yīng)權(quán)限的單元格。重復(fù)一次密碼。 6. 在 SQL Server 中為數(shù)據(jù)庫(kù)開用戶 (1) 啟動(dòng) Microsoft SQL Server EM ,選擇適當(dāng)?shù)姆?wù)器。還可選擇多列。在 Index 組合框里，選擇new，以便創(chuàng)建一個(gè) 新索引。 ② 主關(guān)鍵字的定義必須在數(shù)據(jù)表保存之前，因?yàn)閿?shù)據(jù)表在保存后，所增加的字段將不允許為非 NULL 型。請(qǐng)選擇適當(dāng)?shù)牧校? 使其成為主關(guān)鍵字。隨后會(huì)出現(xiàn) 與表格有關(guān)的更詳細(xì) 的信息。 (3) 單擊 Tables 文件夾旁邊的加號(hào)。 Column name:字段名 Datatype:字段類型 Size:字段長(zhǎng)度 Nulls:是否允許空值 Default:默認(rèn)值 (6) 按 Save 按鈕，保存表格。 (4) 選擇 Table 對(duì)象。單擊所要?jiǎng)?chuàng)建數(shù)據(jù)表的數(shù)據(jù)庫(kù)旁的加號(hào)。請(qǐng)不要復(fù)選 Default Device 選項(xiàng)。出現(xiàn) Manage Database 窗口。 2. 在 SQL SERVER 上創(chuàng)建一個(gè)數(shù)據(jù)庫(kù) (1) 從 Microsoft SQL Server Utilties 程序組內(nèi)打開 SQL EM。出現(xiàn) New Database Device 窗口。如 hfnm.。 SQL Server 主要具有以下幾個(gè)功能： 全面的數(shù)據(jù)完整