19-03-2005
Rozproszone Bazy Danych
mbracha@wshe.lodz.pl
program do pisania skryptów bazy danych:
SQL SERVER – SQL QUERY ANALIZER
Create database Gr6
On
(Name=’Dane’,
Filename= ’c: \ katalog \ baza.mdf’,
Size=1MB,
maxsize=50MB,
filegrowth=1MB)
LOG on
(Name=’LOGI’,
Filename= ’c: \ katalog \ baza . ldf’,
Maxsize=50MB,
Filegrowth= 1MB)
go
Drop database Gr6
Alter database Gr6
Modify file (name =Dane , size=2MB )
Go
Wyłączenie skryptu
--
--Create database Gr6
Use Gr6
create table auta
(NR int IDENTITY (1,1) not null,
Marka varchar (15) not null,
Model varchar (15) not null,
Rocznik varchar (15),
Kolor varchar (15),
Nr_rej varchar (15) not null,
Data_rej datetime)
Drop table auta
insert into auta
(Marka, Model, Rocznik, Kolor,Nr_rej, Data_rej)values
('fiat','126','1991','biały','esi a234',' ')
Pokazanie tabeli
Select * from auta
diabolic