Browse by Tags

All Tags » rowcount (RSS)

Beware of the Usage of SET ROWCOUNT

This is used to set the number of rows affected for DML Declare @test table ( number int ) set rowcount 1 insert into @test select 11 union all select 10 set rowcount 0 select number from @test The above inserts only one row to the table variable @test...
Posted by Madhivanan | with no comments
Filed under: , ,