Bases de Données / Databases

 
INSERT INTO Employe (NumSS, NomE, PrenomE, VilleE, DateNaiss)
SELECT * FROM (
       SELECT	22334, 'Adam', 'Funk', 'Paris', PARSEDATETIME('1-12-1982','dd-mm-yyyy') 		UNION ALL
       SELECT	45566, 'Rachid', 'Allaoui', 'Lyon', PARSEDATETIME('13-4-1986','dd-mm-yyyy') 	UNION ALL
       SELECT	77889, 'Florent', 'Girac' , 'Marseille', PARSEDATETIME('4-11-1990','dd-mm-yyyy')UNION ALL
       SELECT 	90011, 'Mayla', 'Aoun', 'Lyon',  PARSEDATETIME('26-3-1987','dd-mm-yyyy') 		UNION ALL
       SELECT	22233, 'Christine', 'Lara', 'Paris',  PARSEDATETIME('9-8-1982','dd-mm-yyyy') 	UNION ALL
       SELECT	34445, 'Amel', 'Orlando', 'Lyon',  PARSEDATETIME('14-2-1976','dd-mm-yyyy') 		UNION ALL
       SELECT	55666, 'Mohsen', 'Charef', 'Paris',  PARSEDATETIME('28-5-1991','dd-mm-yyyy') 	UNION ALL
       SELECT	77788, 'Tim', 'Arabi', 'Marseille',  PARSEDATETIME('8-6-1984','dd-mm-yyyy') 	UNION ALL
       SELECT	89990, 'Fernando', 'Lopez', 'Lyon',  PARSEDATETIME('5-10-1993','dd-mm-yyyy') 	UNION ALL
       SELECT	11122, 'Ada','Tan Lee', 'Marseille',  PARSEDATETIME('21-3-1994','dd-mm-yyyy') 
);
 
 
 
 
INSERT INTO Projet VALUES (123, 'ADOOP', 22334, 'Paris', 120000);
INSERT INTO Projet VALUES (757, 'SKALA', 45566, 'Lyon', 180000);
INSERT INTO Projet VALUES (890, 'BAJA', 22334, 'Paris', 24000);
 
INSERT INTO grille_sal VALUES ('Admin', 80000);
INSERT INTO grille_sal VALUES ('Deve',45000);
INSERT INTO grille_sal VALUES ('Tech',35000);
 
INSERT INTO Embauche VALUES (77889, 123, PARSEDATETIME('31-05-1985','dd-mm-yyyy') ,'Deve');
INSERT INTO Embauche VALUES (90011, 123, PARSEDATETIME('01-05-2014','dd-mm-yyyy') ,'Tech');
INSERT INTO Embauche VALUES (22233, 757, PARSEDATETIME('01-03-2014','dd-mm-yyyy') ,'Deve');
 
 
SELECT COUNT(*) FROM Employe;
SELECT COUNT(*) FROM projet;
SELECT COUNT(*)  FROM grille_sal;
SELECT COUNT(*)  FROM Embauche;