SQL Server: Pass TOP as @Var parameter in SQL query

Hi,

You can pass dynamic TOP value as parameter in SQL Server 2005 and upwards.

SELECT TOP (@Top) EmployeeId
	 ,Salary
FROM Employees

You can also use it in Stored Procedure.

CREATE PROCEDURE [GetEmployeeSalaries]
    @Top INT
AS
BEGIN
	SELECT TOP (@Top) EmployeeId
	 ,Salary
        FROM Employees
END