When to use ROWCOUNT_BIG ( )

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