When to use ROWCOUNT_BIG ( )

Akiii
Posted by Akiii under Sql Server category on | Points: 40 | Views : 2529
Suppose you have a table which has more than 2 billion rows, Thne simple @@ROWCOUNT will not give you appropiate results. For getting appropiate results you have to use ROWCOUNT_BIG ( ). For example :-

CREATE PROCEDURE demo_procedure	
AS
BEGIN
SET NOCOUNT ON;
SELECT * from tbl_emp;
select ROWCOUNT_BIG ( )
END


The return type of ROWCOUNT_BIG is bigint .



Thanks and Regards
Akiii

Comments or Responses

Login to post response