SQL Server How to parametrize Select top 'n' [duplicate]

pftdvrlh 于 2023-03-22 发布在其他

关注(0)|答案(1)|浏览(122)

This question already has answers here:

Dynamic SELECT TOP @var In SQL Server (6 answers)
Closed yesterday.

I need to write a stored procedure like this but I get an error

Expecting '(', INTEGER, NUMERIC or REAL

This is my procedure code:

CREATE PROCEDURE [dbo].[myStoredProc]
    @numberOfRows int
AS
BEGIN
    SELECT TOP @numberOfRows *
    FROM dbo.myStoredProc   
END

Thank you!

sql-server

来源：https://stackoverflow.com/questions/75783888/how-to-parametrize-select-top-n

1条答案

按热度按时间

juud5qan1#

You're very close - you just need to put the parameter value into brackets - like this:

CREATE PROCEDURE [dbo].[myStoredProc]
    @numberOfRows int
AS
BEGIN
    SELECT TOP (@numberOfRows) *
    FROM dbo.YourTableNameHere 
END

Also, you need to provide a valid table name for your FROM clause - you cannot select from the stored procedure you're just executing - that would be an endless loop in the making ....

See the official MS documentation on TOP for more details

赞(0）回复(0）举报 2023-03-22

我来回答

SQL Server How to parametrize Select top 'n' [duplicate]

1条答案

相关问题

热门标签

最新问答