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
| -- Table des nombres
CREATE TABLE number
(
idNumber INT PRIMARY KEY
);
-- Remplissage table des nombres
DECLARE @i INT = 1;
WHILE @i < 10000
BEGIN
INSERT number VALUES (@i);
SET @i += 1;
END
-- Table des articles
CREATE TABLE article
(
code_article INT,
description VARCHAR(50),
qte INT
);
INSERT article VALUES (1, 'article1', 4);
INSERT article VALUES (2, 'article2', 3);
-- Duplication des lignes
SELECT A.*
FROM article AS A
INNER JOIN number AS NB
ON NB.idNumber <= A.qte |
Partager