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

Menghitung NDVI, LST dan FCD untuk penelitian berbasis remote sensing

-
Image
  Rumus-rumus Matematika NDVI, LST dan FCD NDVI (Normalized Difference Vegetation Index) adalah indeks yang digunakan untuk mengukur kesehatan vegetasi menggunakan data citra satelit. Indeks ini membandingkan reflektansi pada pita merah (RED) dan near-infrared (NIR), yang mencerminkan tingkat vegetasi hijau di permukaan bumi. LST (Land Surface Temperature) adalah suhu permukaan tanah yang dihitung dari data citra satelit menggunakan nilai radiasi termal yang dipancarkan oleh permukaan bumi. LST sering digunakan dalam penelitian lingkungan, seperti pemantauan hutan, analisis iklim, dan studi perubahan lahan. FCD (Forest Canopy Density) adalah indeks yang digunakan untuk menghitung kerapatan tajuk hutan berdasarkan data citra satelit. FCD dihitung menggunakan beberapa parameter seperti NDVI, Bare Soil Index (BI), dan Canopy Shadow Index (SI). Metode ini sering digunakan dalam studi kehutanan, ekologi, dan pengelolaan sumber daya alam. 1.1 Rumus NDVI ………………………………………………………………………………...
Read more

Introduction to Use Case Diagram - Case study: Facebook

-
Image
At this session, will be explained about Use case Diagram. as we know, there are so many diagrams in UML for Analyse and design such as Use Case, Class diagram, Interaction, communication diagrams, etc. Use case can be created to explain business process from the system and to know the relationship between Actor and Use case itself. here is the sample of Facebook which is created in Astah community (Free UML tools) : From the pictures, can be explained that :  the User can update status, send message, edit his profile after he/she log on (in this part use "include"). the Extend in this session have a function as conditional, according to text book of AdegBoyage..continue
Read more

Sequential Search

-
Salam, berikut ini diberikan contoh program menggunakan Sequential Search menggunakan bahasa pemrograman Pascal. Silhakan saudara coba coding menggunakan tools Free pascal. program pencarian_SequenctialSearch; uses crt; const   Nmaks = 100; type   larikInt = array[1..Nmaks] of integer; var   L : larikint;   i : integer;  {indeks Larik}   n : integer;  {banyaknya elemen Larik used}   x : integer; {nilai dicaari}   idx : integer;   procedure bacaLarik(var L:larikInt; n : integer);   var     i : integer;   begin     for i := 1 to n do     begin       write('Masukan nilai L[',i,']:'); readln(L[i]);     end;   end;   procedure cetakLarik(L:larikInt; n : integer);   var     i : integer;   begin     for i := 1 to n do      begin        writeln(L[i]);      end; ...
Read more