December 18, 2018 at 12:08 am
Comments posted to this topic are about the item Counting Transactions
December 18, 2018 at 2:11 am
Great demo to be seen here: https://www.youtube.com/watch?v=aIK6XPSkLQc
December 19, 2018 at 2:17 am
Kendra.Little - Tuesday, December 18, 2018 12:08 AMComments posted to this topic are about the item Counting Transactions
If you run an update statement in autocommit mode, for example, it will be reflected in the counter.
All DML commands are executed in transaction mode. Here is an example that demonstrates this:create table a(i int)
insert into a output @@TRANCOUNT select 1
update a set i = 0 output @@TRANCOUNT
SELECT @@TRANCOUNT
December 19, 2018 at 3:40 am
nice question, ta
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply