你需要两个动态参数，一个在select中，一个在where子句中。



如需参考，请参阅：使用动态SQL存储过程 [ ^ ]



问候..

You need two dynamic parameters, one in select and one in where clause of the query.

For reference,see this : Using Dynamic SQL in Stored Procedures[^]

Regards..