I am testing a query in chained transaction mode and got some confusuin over value of @@trancount and @@transtate:
I have got follwing query:
update CAA_CA set CAA_NAME ='G1' where CAA_CA_ID ='2006000846'
update CAA_CA set CAA_NAME ='G2' where CAA_CA_ID ='2006000847'
Now i have run them in chained mode
After running them result is as expected, no update got executed. Till this point it is ok.
But now @@trancount is showing as 1 and @@transtate = 0
Why @@trancount is still showing 1, it should be 0
and @@transtate should be 3.
If i run in unchained mode then, @@trancount and @@transtate shows values as expected by me.
Is there something that @@trancount and @@transtate also depends upon transaction mode, if yes, please let me know, how?