SQL Server installation and simple use

Installation of SQL Server 2000

1, install SQL Server 2000 Simplified Chinese development version

2, install the SQL Server component

3, install the database server

4, select Local computer

5, create a new SQL Server instance/install Client tool

6, select Server and Client Tools

7, default instance, select Default

8, select Typical installation

9, choose to use local account: No access to network resources

Using Domain Users: User name and domain cleanup

10, select the blending mode, enter the password

Installation Complete

Use of SQL Server 2000

1, open Enterprise Manager

2, right-click the database, create a new database

Enter database name

3, expand the database, there are some default forms

4, create a new table

g_id int 4 identification (primary key) selection is: self-adding field

G_username varchar variable-length strings

G_password varchar 50

G_email varchar 50

G_sex bit 0/1

G_info text

G_date datetime

Save Write table name G_reg