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

Adnaan

Hi,

I have a Stored Proc. I want to dynamically pass the value of TOP.

Please note I cannot use dynamic SQL

Mudassar

0 1

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html