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
@key nvarchar(50),@num int
as
exec ('select top ' + @num + ' * from news where ntitle like ''%@key%'' order by ntime desc')
GO
select top @num * from news where fid=@kid and ntitle like '%@key%' order by ntime desc
又怎么写
谢谢了
exec ('select top ' + @num + ' * from news where fid='+@kid+' ntitle like ''%'+@key+'%'' order by ntime desc')
如果是SQL Server 2005的话,那就是这样:select top (@num) * from news where fid=@kid and ntitle like '%@key%' order by ntime desc