declare @n int;set @n=10
select top(@n) misid,info_id from wl_misid

------解决方案--------------------
declare @n int
set @n=10
select top (@n)  misid,info_id from wl_misid　



------解决方案--------------------
SQL code

--SQL2005

declare @dd int
set @dd = 5
select top(@dd) misid,info_id from wl_misid

--SQL2000

declare @dd int
declare @str varchar(4000)
set @dd = 5
set @str = 'select top ' + ltrim(@dd) + ' misid,info_id from wl_misid'
exec(@str)

------解决方案--------------------
SQL code
--如果是SQL SERVER 2000
declare @n int;set @n=10

declare @sql varchar(8000)
set @sql='select top '+ltrim(@n)+' misid,info_id from wl_misid'
exec(@sql)