SQL Server Installation and simple use

Installation of sqlserver 2000

1. Install SQL server 2000 Simplified Chinese development Edition

2. Install the SQL server Component

3. Install the Database Server

4. Select the Local Computer

5. Create a new SQL server instance/install the client Tool

6. Select the server and client tools.

7. Default instance.

8. Select a typical Installation

9. Select a local account to access network resources.

Domain Users: CLEAR user names and Domains

10. Select hybrid mode and enter the password.

Installation Complete

Use of sqlserver 2000

1. Open the Enterprise Manager

2. Right-click the database and create a new database.

Enter Database Name

3. Expand the database with some default tables.

4. Create a table

G_id int 4 (primary key): auto-increment Field

G_username varchar variable-length string

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