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
|
BEGIN TRANSACTION MaTransaction
INSERT INTO auditeur VALUES (7,'hayaoui','samad','01/01/2000',18)
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION MaTransaction
RETURN -1
END
INSERT INTO auditeur VALUES (8,'redwan','samad','01/07/2000',18)
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION MaTransaction
RETURN -1
END
INSERT INTO auditeur VALUES (9,'poul','samad','01/05/2000',18)
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION MaTransaction
RETURN -1
END
INSERT INTO auditeur VALUES (10,'geroger','amine','01/08/2000',18)
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION MaTransaction
RETURN -1
END
INSERT INTO auditeur VALUES (10, 'geroger','amine','01/08/2000',18)
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION MaTransaction
RETURN -1
END
COMMIT TRANSACTION MaTransaction |
Partager