CREATE TABLE herci
(
id int IDENTITY (1,1) NOT FOR REPLICATION PRIMARY KEY,
jmeno VARCHAR(10),
prijmeni VARCHAR (10)
);
INSERT INTO herci VALUES (Sean,Connery);
INSERT INTO herci VALUES (George,Lazenby);
INSERT INTO herci VALUES (Roger,Moore);
INSERT INTO herci VALUES (Timothy,Dalton);
INSERT INTO herci VALUES (Pierce,Brosnan);
CREATE TABLE filmy
(
cislo int IDENTITY (1,1) NOT FOR REPLICATION PRIMARY KEY,
nazev VARCHAR(40),
herec INT,
rok INT
);
INSERT INTO filmy VALUES (Dr. No,1, 1962);
INSERT INTO filmy VALUES (From Russia With Love, 1, 1963);
INSERT INTO filmy VALUES (Goldfinger, 1, 1964);
INSERT INTO filmy VALUES (Thunderball, 1, 1965);
INSERT INTO filmy VALUES (You Only Live Twice, 1, 1967);
INSERT INTO filmy VALUES (On Her Majesty Secret Service, 2, 1969);
INSERT INTO filmy VALUES (Diamonds Are Forever, 1, 1971);
INSERT INTO filmy VALUES (Live And Let Die, 3, 1973);
INSERT INTO filmy VALUES (The Man With The Golden Gun, 3, 1974);
INSERT INTO filmy VALUES (The Spy Who Loved Me, 3, 1977);
INSERT INTO filmy VALUES (Moonraker , 3, 1979);
INSERT INTO filmy VALUES (For Your Eyes Only, 3, 1981);
INSERT INTO filmy VALUES (Octopussy, 3, 1983);
INSERT INTO filmy VALUES (A View To A Kill, 3, 1985);
INSERT INTO filmy VALUES (The Living Daylights, 4, 1987);
INSERT INTO filmy VALUES (Licence To Kill, 4, 1989);
INSERT INTO filmy VALUES (GoldenEye, 5, 1995);
INSERT INTO filmy VALUES (Tomorrow Never Dies, 5, 1997);
INSERT INTO filmy VALUES (The World Is Not Enough, 5, 1999);
INSERT INTO filmy VALUES (Die Another Day, 5, 2002);