[Bug] incorrect syntax near '@ end '.

Case study: The following SQL statement is used for paging,

Select f_id, f_card, f_avabegin, f_avaend, f_edittime from
(Select top @ end * from
(Select top @ start * From t_trade_card_usefullife
Where f_card = @ f_card
Order by f_edittime DESC) derivetbl
Order by f_edittime)
Order by f_edittime DESC

The following error is displayed during running: incorrect syntax near '@ end '.
Incorrect syntax near '@ start '.
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.

Exception details: system. Data. sqlclient. sqlexception: incorrect syntax near '@ end '.
Incorrect syntax near '@ start '.

It seems that I have been searching for SQL statements because these parameters are provided by the sqlparameter set. If I replace these parameters directly with values, the program can run correctly, it seems that it is indeed from the end and start errors, after continuous debugging, and bold speculation, finally added brackets in the parameter, the problem is solved. The SQL statement is as follows: Select f_id, f_card, f_avabegin, f_avaend, f_edittime from
(Select top (@ end) * from
(Select top (@ start) * From t_trade_card_usefullife
Where f_card = @ f_card
Order by f_edittime DESC) derivetbl
Order by f_edittime)
Order by f_edittime DESC