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