开发基于SQL Server 的C/S数据库应用系统

                Development based on SQL SERVER C/S database application system
SQL the Server  achievement face the small and medium-sized enterprise the network database service system, has provided with the multitudinous high-level 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; In data bank administration aspect: SQL Server  the way which easy to manage by one kind processes the multi- servers business management, provided one kind system to expand SQL the Server surpasses the single computer capacity the method.
SQL Server  mainly has following several functions：
Comprehensive data integrity protection, regardless of is the complex business support and the high-level security, or hides the type face user's database to be partial, as well as the data integrity protection all is suitable;
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;
Also has the prominent performance in the low construction cost platform;
Provides the first-class management tool for the system manager;
To multi-processor "distributional" business intrinsic support.
Below introduced how one kind does use Microsoft SQL Server  to construct the development environment on Windows NT Server, completes the general customer/server application system.
on  founds a data equipment in SQL SERVER (in front of foundation database must for this database found a storage device)
procedure group opens SQL EM from Microsoft SQL Server in  Utilties.
In Server in Manager window, choice foundation database server. If hfnm. .
Chooses the Manage vegetable single item, then chooses Database the Device option. Appears Manage Database the Device window.
Chooses New the Device button (first). Appears New Database the Device window.
Name: For equipment which must found; Location: May choose founds the equipment the place (for example: C: \ databas e); Size (MB): Uses in to establish this equipment the size (generally for database 1.25 times).
Single-clicks 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); Logic Device is the database logic equipment name, Size is this logical equipment for the database assignment storage space (MB). Please does not want reelection Default the Device option.
(6) according to Create the Now button, officially founds the database.
3. in the database which has founded the data sheet
(1) procedure group to open SQL EM from Microsoft SQL Server in  Utilties. (2) in Server in the Manager window, chooses the server. Single-clicks must found the data sheet nearby the database plus sign. Again single-clicks the database Group/Users as well as the Objects module.
(3) single-clicks nearby the Objects module the plus sign. Server Manager will launch the Objects project, and demonstrated might operate all databases object.
(4) chooses the Table object. Then single-clicks the Manager vegetable single item, and chooses the Tables project. Will appear Manager Table (management form) the window.
(5) the present maintains the Table combination frame for (if were combining frame to choose other tables, then was allowed to revise it). Column name: Field name Datatype: Field type □Size: Field length Nulls: Whether permits spatial value □Default: Tacitly approves the value
(6) according to the Save button, preserves the form.
4. founds the host essential character for the data sheet
(1) to start Microsoft SQL Server  EM, chooses the suitable server as well as the database. Single-clicks nearby the database the plus sign, Server Manager can launch the database, juxtaposes all modules.
(2) single-clicks nearby the Objects project the plus sign, Server Manager can list the database object which may operate.
(3) single-clicks nearby the Tables folder the plus sign. Clicks on the corresponding data sheet object with the right key, then from springs in the type menu to choose the Edit order. Afterwards on the screen can appear Manage the Tables window.
(4) single-clicks on the tool fence Advanced Features (high-level characteristic) the button. Afterwards can appear with the form related more detailed information.
(5) in the first card (Primary Key/Identity) in, may suppose the buyer essential character. Single-clicks in Primary Key window frame Column Names (a row name) to combine the frame. Can demonstrate has not supposed is the Nulls a series of rows name. Please choose the suitable row, causes it to become primarily the essential character.
(6) said regarding the host essential character that, the index type should define as (non-clustered). Single-clicks the Add button, increases the host essential character information in the form. □attention:
host essential character definition regarding a data sheet said is count for much, if has not advocated the essential character, then this data sheet will be read-only.
b) host essential character definition must before the data sheet preservation, because the data sheet after the preservation, increases the field will not permit for non- NULL.
5. gathers in great number the index for the form foundation
(1) to start SQL EM, chooses the corresponding database.
(2) chooses the Indexes option from the Manage menu.
(3) in the Table combination frame, chooses the suitable data sheet. In Index combination frame, choice, in order to founds a recent index. Inputs the recent index in inside the name. In
(4) (in form may use row) in Available Columns In Table to tabulate, chooses the suitable row and presses down the Add button. This can arrange in order the name to move to Columns In Index (Key) tabulates the frame. Also may choose the multi- rows.
(5) in Index Attribute (index attribute) in the window frame, chooses Clustered (to gather in great number) the reelection frame.
(6) in Clustered two Shan Xuanniu, Allow duplicate rows expression permission repetition line.
(7) according to the Build button, starts to found the index.