1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| CREATE PROCEDURE dbo.addAction
@date varchar(10) , @heure varchar(5) , @action varchar(200) , @incident int , @user int
AS
declare @iddate int
select id_date into @iddate
from date
where date_action = @date
and heure_action = @heure
if (@iddate=Null)
insert into date(date_action, heure_action) values (@date, @heure)
select id_date into @iddate
from date
where date_action = @date
and heure_action = @heure
insert into suivi values (@iddate, @incident, @user, @action) |
Partager