declare @PageSize int, @PageNumber int, @EMPName varchar(100) SET @PageSize=10 SET @PageNumber=1 SET @EMPName='' SELECT TOP(@PageSize) * FROM ....