SELECT TOP 20 * FROM HumanResources.Employee DECLARE @top INT SET @top = 10 SELECT TOP(@top) * FROM HumanResources.Employee -- set value DECLARE @top INT SET @top = 10 SET ROWCOUNT @top SELECT * FROM HumanResources.Employee -- set value to return all rows SET ROWCOUNT 0 -- update example DECLARE @top INT SET @top = 10 UPDATE TOP(@top) HumanResources.Employee SET MaritalStatus = 'S' WHERE Employe..