SQL 存储过程中select top 带参数的方法
如下:
declare @test int declare @str varchar(8000) set @test = 5
set @str =select top + cast(@test as varchar(10)) + c_id from t_comment exec(@str)