1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Create Procedure Insert_Incident_Hist2(@Login_Creation varchar(50),
@Login_Assigned varchar(50),
@Id_Type int,
@Id_Priorite int,
@Objet varchar(50),
@Description varchar(50),
@Date_Etat date)
as
DECLARE @ID_INCIDENT NUMERIC(18)
SET @ID_INCIDENT = @@identity
BEGIN
Insert into Incident (Login_Creation, Login_Assigned,Id_Type,Id_Priorite,Objet,Description)
values(@Login_Creation,@Login_Assigned,@Id_Type,@Id_Priorite,@Objet,@Description)
Insert into Incident_Hist (Id_Incident,Id_Etat,Login_Assigned,Date_Etat)
Values(@ID_INCIDENT,1,@Login_Assigned,@Date_Etat)
END |
Partager