若是要给"select top n * ..." 给n传参数,则需采用拼凑sql的方法。
方法1: declare @test int
declare @str varchar(8000)
set @test = 5
set @str = 'select top ' + str(@test) + ' menu_id from sys_menu'
exec(@str)
方法2: declare @test int
declare @str varchar(8000)
set @test = 5
set @str = 'select top ' + cast(@test as varchar(10)) + ' menu_id from sys_menu'
exec(@str)
责任编辑:小草