How to make database in SQL Server 2000

Well, we must have known about Database Management System of SQL Server 2000, right. Yup, the DBMS manufactured by Microsoft and for some programmers these days who use software from Microsoft, Borland and other be enjoy using this DBMS. In this section, we will learn on how to make database in SQL Server 2000 with query Analizer, why Query analizer, we hope by studying T-SQL we can be familiar to other similar DBMS like MySQL and Oracle, here we are :

Firstly, log on to MS-SQL Server --> Query Analizer, in GUI of Query analizer, firstly we can find six default DBMS like Master, Nortwind and others :
2. Create database try_DB , it means after you write create database database_name, press F5 yo execute
3. Use try_DB .

Then, for instance, we are going to make table of Student, so we make code bellow :
Create table Student(
Id_number char(7) primary key,
Name varchar(35) not null,
faculty varchar(35),
Department varchar(30),
Mail varchar(50))

Well, the last, how to appear on window, here is the code :
Select * from try_DB
It' easy right, so just try, it will be more nice if we create application and connect to the database :).


Popular posts from this blog

Introduction to Use Case Diagram - Case study: Facebook

Kenapa tidak berkurban?

Sequential Search