[TSQL] Cisto iz firbca; TRAN_ABORT

Sem nasel primer (proti koncu strani), da naredis transakcijo v TSQLu:
SET XACT_ABORT ON
BEGIN TRY
BEGIN TRAN
INSERT INTO T1 VALUES(1)
/* perform other activity */
PRINT 'After INSERT.'
COMMIT
END TRY
BEGIN CATCH TRAN_ABORT
ROLLBACK
/* perform corrective activity */
PRINT 'INSERT failed.'
END CATCH


No, in men ta TRAN_ABORT noce sprejet, ker dobim error:
Incorrect syntax near 'TRAN_ABORT'.

Prav tako sem nasel en drug primer, kjer je namesto COMMIT uporabljen COMMIT TRAN. Razlike pa nisem nasel.


by Miha

Ne.