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 But beware that this wont be supported in Future...