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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
|
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=chifco2014jaafar;Data Source=JAAFAR-PC;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=JAAFAR-PC;Use Encryption for Data=False;Tag with column collation when possible=False];
//-------- Start Multiple Select Statements ------Section Access;
//-------- Start Multiple Select Statements ------
SQL SELECT "Id_Bulding_PK",
Nameofbulding,
NumberofPerson,
"Ville_Client"
FROM chifco2014jaafar.dbo.DimBulding;//-------- Start Multiple Select Statements ------
SQL SELECT "Id_Device_PK",
NameDevice
FROM chifco2014jaafar.dbo.DimDevice;
SQL SELECT "ID_Equipement_PK",
"Name_Equipement"
FROM chifco2014jaafar.dbo.DimEquipement;
//-------- Start Multiple Select Statements ------
SQL SELECT "Id_Rooms_pk",
NameRooms
FROM chifco2014jaafar.dbo.DimRooms;
SQL SELECT "Id_Floors",
NameFloors
FROM chifco2014jaafar.dbo.DimFloor;
//-------- End Multiple Select Statements ------
SQL SELECT Date,
"Date_Nom",
"PK_Date",
Semaine
FROM chifco2014jaafar.dbo.DimTemps;
//-------- End Multiple Select Statements ------
SQL SELECT Adresse,
Birthday,
"Id_Client_PK",
LastName as LastName,
Name as Prenom
FROM chifco2014jaafar.dbo.DimClient;
//-------- Start Multiple Select Statements ------
SQL SELECT Appreil,
"consommation moyenne",
"ID_ConsMoyenen_PK",
Periode,
Puissance,
Type
FROM chifco2014jaafar.dbo.dimConsommationMoyenne;
//-------- End Multiple Select Statements ------
//-------- Start Multiple Select Statements ------
SQL SELECT "Consomation Energie",
EtatMultisenser,
"ID_Bulding_FK" as Id_Bulding_PK ,
"ID_Client_FK" as Id_Client_PK,
"ID_Device_FK" as Id_Device_PK ,
"ID_equipement_FK" as ID_Equipement_PK ,
"ID_Floors_FK" as Id_Floors,
"ID_Romms_FK" Id_Rooms_pk,
"ID_Temps_FK" as PK_Date ,
"ID_ConsMoyenen__FK" as ID_ConsMoyenen_PK ,
Temperature//-------- Start Multiple Select Statements ------
FROM chifco2014jaafar.dbo.FactConsommation; |
Partager