DECLARE @SortCol VARCHAR(100) DECLARE @SortDir VARCHAR(4) DECLARE @top INTEGER SET @SortCol = 'userId' SET @SortDir = 'ASC' SET @top = 5 SELECT TOP(@top) userId ,username FROM users ORDER BY @SortCol @SortDir