存储过程中用top问题

[pwalai]

CREATE PROCEDURE guest_search1
@key nvarchar(50),@num int
as
select top @num * from news where ntitle like '%@key%' order by ntime desc
GO

select top 后面好像不能放参数

在论坛上找了下可以
exec(' select top '@num +' * from news') 实现

但是后面还有@key 参数 怎么连接呢

[Limpire]

CREATE PROCEDURE guest_search1
 @key nvarchar(50),@num int
as
exec ('select top ' + @num + ' * from news where ntitle like ''%@key%'' order by ntime desc')
GO

[pwalai]

请问2楼这么写的@key是当作参数吗？

[中国风]

exec ('select top ' + @num + ' * from news where ntitle like '''+%@key%+''' order by ntime desc')

[中国风]

exec ('select top ' + @num + ' * from news where ntitle like ''%'+@key+'%'' order by ntime desc')

[pwalai]

如果是
select top @num * from news where fid=@kid and ntitle like '%@key%' order by ntime desc
又怎么写
谢谢了

[pwalai]

是不是
exec ('select top ' + @num + ' * from news where fid='+@kid+' ntitle like ''%'+@key+'%'' order by ntime desc')

[pwalai]

exec   ('select   top   '   +   @num   +   '   *   from   news   where   fid='+@kid+'   ntitle   like   ''%'+@key+'%''   order   by   ntime   desc')

[csjtxy]

请问是用SQL Server 2000吗？那就上面的高手已经给出了。
如果是SQL Server　2005的话，那就是这样：

select top (@num) * from news where fid=@kid and ntitle like '%@key%' order by ntime desc