如何對SELECT TOP @topN 做參數傳入查詢_Incorrect syntax near '@topN'問題排除

 

由於直接

SELECT TOP @topN .....

這樣子搭配ado.net 執行會一直報錯

Incorrect syntax near '@topN'

因此經上網查才發現要多加一組括號....(還滿多人遇到的)

SELECT TOP (@topN) .....

但是如果只是單純這樣改仍有機會碰到錯誤

The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer.

必須強制轉型讓其被識別為INT

SELECT TOP (cast(@topN as int)) .....

Ref:

SQL: How do I use parameter for TOP like in SELECT TOP @amount? [duplicate]

https://stackoverflow.com/questions/1936496/sql-how-do-i-use-parameter-for-top-like-in-select-top-amount

The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer

https://stackoverflow.com/questions/59981346/the-number-of-rows-provided-for-a-top-or-fetch-clauses-row-count-parameter-must

Issue using variable and TOP clause

https://stackoverflow.com/questions/11420535/issue-using-variable-and-top-clause