subject:@@TRANCOUNT
syntax:@@TRANCOUNT
content:ใช้คืนค่า จำนวนของ transaction ที่เปิดใช้อยู่
example:BEGIN TRANSACTION tran_outerest
PRINT @@TRANCOUNT
BEGIN TRANSACTION tran_inner_1
SELECT id, firstname, lastname, sex FROM person
UPDATE person SET firstname = 'Mr. ' + firstname WHERE set = 1
UPDATE person SET firstname = 'Mrs. ' + firstname WHERE set = 2
COMMIT TRANSACTION tran_inner_1
PRINT @@TRANCOUNT
BEGIN TRANSACTION tran_inner_2
INSERT INTO person ( firstname, lastname, sex ) VALUES ( 'function', 'in.th', 1 )
IF @@ERROR > 0
BEGIN
ROLLBACK TRANSACTION tran_inner_2
END
COMMIT TRANSACTION tran_inner_2
PRINT @@TRANCOUNT
COMMIT TRANSACTION tran_outerest
PRINT @@TRANCOUNT
