I have a
datagridview
n
buttun
Top N
//retrieving Top N Records
SELECT Top @Rows FROM CaseDetails //@Row is parameter
//retrieving All records
SELECT Top (SELECT COUNT(*) FROM CaseDetails) FROM CaseDetails
SQL Server
This is working fine
Declare parameters
Create Procedure uspRetrieve
@Rows int =NULL
AS
BEGIN
SET NOCOUNT ON;
SET ROWCOUNT @Rows
SELECT * FROM CaseDetails
End
IF you supply @Row=0 you will get all records else you get @Row =your limit