home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2002 April
/
Chip_2002-04_cd1.bin
/
chplus
/
asp
/
dil3_SQL.txt
< prev
next >
Wrap
Text File
|
1999-04-10
|
1KB
|
31 lines
-- tabulky ---------------------------------------
drop table ZAMESTNANCI
go
-------------------------
create table ZAMESTNANCI (
-------------------------
ID integer identity,
JMENO varchar(50) null,
PRIJMENI varchar(50) null,
POHLAVI varchar(4) null,
VEK integer null,
constraint PK_FIRMA primary key (ID))
-- data ------------------------------------------
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Pepa', 'D²evo', 'muº', 35)
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Honza', 'Hloup∞', 'muº', 20)
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Radka', 'Chytrá', 'ºena', 40)
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Pavel', 'Kopyto', 'muº', 19)
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Jan', 'Novont∞', 'muº', 26)
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Katka', 'Záhorská', 'ºena', 46)
insert into ZAMESTNANCI (JMENO, PRIJMENI, POHLAVI, VEK)
values ('Pavla', 'Pavlovna', 'muº', 55)