1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| -- ON CREE UNE TABLE CONTENANT LES ELEMENTS A CLASSER
CREATE TABLE tbl_Fruits
(Num INT IDENTITY(1,1) PRIMARY KEY,
Label VARCHAR(10))
-- ON L'ALIMENTE
INSERT INTO tbl_Fruits VALUES('Pomme')
INSERT INTO tbl_Fruits VALUES('Ananas')
INSERT INTO tbl_Fruits VALUES('Kiwi')
INSERT INTO tbl_Fruits VALUES('Orange')
-- ON CREE UNE TABLE DE TRI...
CREATE TABLE tbl_Fruit_Sort
(Num INT IDENTITY(1,1),
FruitId INT NOT NULL,
FruitOrder INT)
-- ...LIEE A LA TABLE DES ELEMENTS PAR UNE FK
ALTER TABLE tbl_Fruit_Sort ADD CONSTRAINT FK_fruit_order FOREIGN KEY(FruitId) REFERENCES Tbl_Fruits(Num)
-- ON L'ALIMENTE
INSERT INTO Tbl_Fruit_Sort
(FruitID,FruitOrder)
VALUES (1,3)
INSERT INTO Tbl_Fruit_Sort
(FruitID,FruitOrder)
VALUES (3,2)
INSERT INTO Tbl_Fruit_Sort
(FruitID,FruitOrder)
VALUES (4,4)
INSERT INTO Tbl_Fruit_Sort
(FruitID,FruitOrder)
VALUES (2,1) |
Partager