1 2 3 4 5 6 7 8 9 10
| CREATE procedure rechM (@nb_expr int,@annee_dipl char(4))
as begin
CREATE VIEW allCV
AS select email, langue_CV from Candidat can, CV cv where can.email=cv.CandidatID group by email,langue_CV
if (@nb_expr is not NULL) begin
alter view allCV as ((select email, langue_CV from allCV) intersect (select email,langue_CV from v_NbrExpr where (nbr_exp=@nb_expr)) GO end
if (@annee_dipl is not NULL) begin
alter view allCV as ((select email, langue_CV from allCV) intersect (select email,langue_CV from v_dern_dip where dern_dip=@annee_dipl)) GO end
end |
Partager