1 2 3 4 5 6
|
exec sp_executesql N'UPDATE TOP (200) situation_personnelle SET NOM = @NOM WHERE (MATRICULE = @Param1) AND (CIN = @Param2) AND (NOM = @Param3)
AND (PRENOM = @Param4) AND (DATENAISSANCE = @Param5) AND (LIEUNAISSANCE = @Param6) AND (SEXE = @Param7) AND (SITUATIONFAMILIALE = @Param8)
AND (DATERECRUTEMENT = @Param9) AND (ADRESSE = @Param10) AND (TELEPHONE IS NULL) AND (EMAIL IS NULL) AND (PERSONNEID = @Param11)',N'@NOM nvarchar(5),@Param1 nvarchar(4),
@Param2 nvarchar(6),@Param3 nvarchar(6),@Param4 nvarchar(5),@Param5 date,@Param6 nvarchar(5),@Param7 nvarchar(1),@Param8 nvarchar(3),@Param9 date,@Param10 nvarchar(9),@Param11 int',@NOM=N'Salim',@Param1=N'5454',@Param2=N'123456',@Param3=N'Salima',@Param4=N'amine',@Param5='1955-05-05',@Param6=N'oujda',@Param7=N'M',@Param8=N'MAR',@Param9='1988-05-05',
@Param10=N'qv nakhil',@Param11=19 |
Partager