Page 530 - IT2
P. 530
Select @idStagiaire=idStagiaire, @idModule=idModule From Inserted
Select @idFiliere=idFiliere Stagiaire Where idStagiaire=@idStagiaire
IF NOT EXISTS (Select idModule From Fil_Module Where idModule=@idModule And
idFiliere=@idFiliere)
Rollback
3) Create Trigger question3 On Absence After Insert
As
Declare @idStagiaire int
Select @idStagiaire=idStagiaire From Inserted
Update Stagiaire set TotalAbsence=TotalAbsence + 1 Where idStagiaire=@idStagiaire
4) Create Function Dbo.question4 (@idStagiaire int)
Returns int
As
Begin
Declare @n int, @resultat int
Select @n=count(idAbsence) From Absence Where idStagiaire=@idStagiaire and TypeAbsence
= ’non justifiée’
Set @resultat = 20 - @n
If @resultat < 0
Set @resultat =0
Return @resultat
End
5) Create procedure question5 @idModule int
As
Declare @limite decimal
Select @limite = 0.3 * NbreHeure From Module Where idModule=@idModule
Select nom,prenom From Stagiaire S inner join Absence A ON S.idStagiaire=A.idStagiaire Where
idModule=@idModule Having 2.5*count(idAbsence) > @limite
6) Select distinct S.nom, S.prenom From Stagiaire S, Absence A1, Absence A2 Where A1.idStagiaire=
S.idStagiaire and A2.idStagiaire= S.idStagiaire and A2.dateAbs > A1.dateAbs and DATEDIFF(day,
A1.dateAbs, A2.dateAbs) <= 15
Dossier 4 :
1)
<html>
<head>
<title></title>
</head>
<body>
<h1>Inscription</h1>
<form name="f" action="">
<p>
Nom :
<input id="nom" type="text" /> prénom :
<input id="prenom" type="text" /></p>
<p>
Age :
Filière Epreuve Session
TDI Théorique FF Juillet 2014 5/8
www.itlearning-settat.com
Email: admission@itlearning-settat.com
Tél.:0661077812
