Creating database using Sql server 2000

Creating database in sql 2000 is a very simple process.You can do this in two ways

By using Query analyzer

1.Take start>All programs>Microsoft sql server>query analyzer


 2.Give userid and password of sql server that you set during installation
   Tick the box  "Start sql server if stopped"



3.Now you can write the queries to create tables and database in the white part.

4.To execute the query..select the query and press  f5.






Using Enterprise manager






1.Take start>all programs>Microsoft sql server>Enterprise manager
2.On the left panel select   Microsoft sql server>sql server group>(local)(windows NT)
3.To create new database ,right click on the database and there is an option to create new    database there.
4.To create a new table ,select the databae name>Right click on tables >New table

5.A new pop up window will open.On that window give the necessary column names and datatypes

Creating auto incrementing columns


Autoincrementing columns are columns whose value is incremented each time a new row is entered into a table .

This is useful for generating  a unique id automatically for each entry.


Steps

1.ON the page design pop up window in enterprise manager.Create a new column


2.Make its datatype as int


3.On the bottom maket identity 'Yes'

4.Set identity seed and identity increment to your desired values .