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
|
create proc p_insert
(@Categorie varchar(30),
@Element varchar(30),
@Duree datetime)
as
begin
declare @CleParent int, @CleFils int, @err int
begin tran
insert into Categorie (LibelleCategorie) values(@Categorie)
select @err=@err+@@error, @CleParent=@@identity
insert into Element (Idcategorie, NomElement)
values (@CleParent, @Element)
select @err=@err+@@error, @CleFils=@@identity
insert into CategorieElement (idCategorie,IdElement, DureeElement)
values (@CleParent, @CleFils, @Duree)
select @err=@err+@@error
if @err <> 0
begin
print 'erreur en insertion'
rollback
end
else
commit
end |
Partager