1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| ALTER PROCEDURE [dbo].[InsertAppel]
@poste BIGINT,
@destination BIGINT,
@tel BIGINT,
@debut DATETIME,
@fin DATETIME,
@typeDebut BIGINT,
@typeFin BIGINT,
@duree BIGINT
AS
BEGIN
BEGIN Tran
INSERT INTO appel
(
id_Poste,
id_Telephone,
id_Destinataire,
date_debut,
date_fin,
type_jour_debut,
type_jour_fin,
duree
)
VALUES
(
@poste,
@tel,
@destination,
@debut,
@fin,
@typeDebut,
@typeFin,
@duree
)
SELECT identifiant
FROM appel
WHERE id_Poste=@poste
AND id_Telephone=@tel
AND id_Destinataire=@destination
AND date_debut=@debut
AND date_fin=@fin
COMMIT TRAN
END |
Partager