Pages

Tuesday, January 18, 2011

CREATE

CREATE

-=========================================[CREATE]====================================================================
--Create is used to create Database or Tables.

--Create Database (with default parameters)---
CREATE DATABASE testdb

--Create Table (Proper DB should be selected, here testdb is selected)
CREATE TABLE employee(
     ID          int,
     name        nvarchar (10),
     salary      int,
     start_date  datetime,
     city        nvarchar (10),
     region      char (1))

 INSERT INTO employee (ID, name,    salary, start_date, city,       region)
               values (1,  'Jason', 40420,  '02/01/94', 'New York', 'W')
 INSERT INTO employee (ID, name,    salary, start_date, city,       region)
               values (2,  'Robert',14420,  '01/02/95', 'Vancouver','N')
 INSERT INTO employee (ID, name,    salary, start_date, city,       region)
               values (3,  'Habib', 90020,  '12/03/99', 'Toronto',  'W')
 INSERT INTO employee (ID, name,    salary, start_date, city,       region)
               values (4,  'Linda', 40620,  '11/04/97', 'New York', 'N')
 INSERT INTO employee (ID, name,    salary, start_date, city,       region)
               values (5,  'David', 80026,  '10/05/98', 'Vancouver','W')

SELECT * FROM employee

Eigrp Configuration (no-auto summary)



R1
Router>en
Router#conf t
Router(config)#hostname R1
R1(config)#int f0/0
R1(config-if)#ip address 200.0.0.17 255.255.255.240
R1(config-if)#no shut
R1(config-if)#int s2/0
R1(config-if)#ip address 200.0.0.33 255.255.255.240
R1(config-if)#no shut
R1(config-if)#clock rate 64000
R1(config-if)#int s3/0
R1(config-if)#ip address 200.0.0.49 255.255.255.240
R1(config-if)#no shut
R1(config-if)#clock rate 64000
R1(config-if)#exit
R1(config)#router eigrp 100
R1(config-router)#network 200.0.0.16
R1(config-router)#network 200.0.0.32
R1(config-router)#network 200.0.0.48
R1(config-router)#no auto-summary
R1(config-router)#exit
R1(config)#exit
R1#write







R2
Router>en
Router#conf t
Router(config)#hostname R2
R2(config)#int s2/0
R2(config-if)#ip address 200.0.0.34 255.255.255.240
R2(config-if)#no shut
R2(config-if)#clock rate 64000
R2(config-if)#int s3/0
R2(config-if)#ip address 200.0.0.65 255.255.255.240
R2(config-if)#no shut
R2(config-if)#clock rate 64000
R2(config-if)#exit
R2(config)#router eigrp 100
R2(config-router)#network 200.0.0.32
R2(config-router)#network 200.0.0.32
R2(config-router)#network 200.0.0.64
R2(config-router)#exit
R2(config)#exit
R2#write


R3
Router>en
Router#conf  t
Router(config)#hostname R3
R3(config)#int s2/0
R3(config-if)#ip address 200.0.0.66 255.255.255.240
R3(config-if)#no shut
R3(config-if)#clock rate 64000
R3(config-if)#int s3/0
R3(config-if)#ip address 200.0.0.81 255.255.255.240
R3(config-if)#no shut
R3(config-if)#clock rate 64000
R3(config-if)#exit
R3(config)#router eigrp 100
R3(config-router)#network 200.0.0.64
R3(config-router)#network 200.0.0.64
R3(config-router)#network 200.0.0.80
R3(config-router)#exit
R3(config)#exit
R3#write





R4
Router>en
Router#conf t
Router(config)#hostname R4
R4(config)#int f0/0
R4(config-if)#ip address 200.0.0.97 255.255.255.240
R4(config-if)#no shut
R4(config-if)#int s2/0
R4(config-if)#ip address 200.0.0.82 255.255.255.240
R4(config-if)#no shut
R4(config-if)#clock rate 64000
R4(config-if)#int s3/0
R4(config-if)#ip address 200.0.0.113 255.255.255.240
R4(config-if)#no shut
R4(config-if)#clock rate 6400
Unknown clock rate
R4(config-if)#clock rate 64000
R4(config-if)#exit
R4(config)#router eigrp 100
R4(config-router)#network 200.0.0.80
R4(config-router)#network 200.0.0.96
R4(config-router)#network 200.0.0.112
R4(config-router)#exit
R4(config)#exit
R4#write



R5
Router>en
Router#conf t
Router(config)#hostname R5
R5(config)#int s2/0
R5(config-if)#ip address 200.0.0.129 255.255.255.240
R5(config-if)#no shut
R5(config-if)#clock rate 64000
R5(config-if)#int s3/0
R5(config-if)#ip address 200.0.0.114 255.255.255.240
R5(config-if)#no shut
R5(config-if)#clock rate 64000
R5(config-if)#exit
R5(config)#router eigrp 100
R5(config-router)#network 200.0.0.112
R5(config-router)#network 200.0.0.128
R5(config-router)#exit
R5(config)#exit
R5#write


R6
Router>en
Router#
Router#conf t
Router(config)#hostname R6
R6(config)#int s2/0
R6(config-if)#ip address  200.0.0.50 255.255.255.240
R6(config-if)#no shut
R6(config-if)#clock rate 64000
R6(config-if)#int s3/0
R6(config-if)#ip address  200.0.0.130 255.255.255.240
R6(config-if)#no shut
R6(config-if)#clock rate 64000
R6(config-if)#exit
R6(config)#router eigrp 100
R6(config-router)#network 200.0.0.48
R6(config-router)#network 200.0.0.128
R6(config-router)#exit
R6(config)#exit
R6#write