Browse by Tags

Tagged Content List
  • Blog Post: Usage of @@Trancount in DML statements

    Some time ago I got an interesting questions why the following applies: -- drop table a create table a(m varchar ( max ), i int ) go declare @cnt int --Explicit transaction begin tran set @cnt=@@trancount insert into a select 'inside' , @@trancount insert into a select 'inside...
Page 1 of 1 (1 items)