7
Shouts

@@TRANCOUNT is always incremented in a trigger

published 475 days, 1 hour, 41 minutes ago posted by dharadhara 478 days, 18 hours, 16 minutes ago
Tuesday, January 31, 2012 11:14:37 AM GMT Friday, January 27, 2012 6:39:12 PM GMT

The system variable @@TRANCOUNT is used to get the number of transactions that are active. Consider the following code begin transaction select 3 select @@TRANCOUNT commit transaction The result of @@TRANCOUNT is 1. Consider the following code. begin...

category: Data | clicked: 6 | | source: beyondrelational.com | show counter code
tags: SQL Server, TSQL