Actually I neet to do paging in ASP.NET application. I have created a Stored Procedure, which takes two parameters(@From, @To). I don't want to use primary key column, because there...
You could use SQL Server System function @@ROWCOUNT which return the number of rows affected by the last statement. At the end of procedure write return statement (Return @@ROWCOUNT) and get...