提出最新几条信息用存储过程,加top为什么不行?? (30分)
create proc info
@topsl int
as
declare @s varchar(5000)
begin
set @s= 'SELECT top '+@topsl+ ' * from users order by id desc '
exec (@s)
end
go


前台调用:
set rs = server.createobject( "adodb.recordset ")
rs.Open " exec info 5 ",conn,1,1


以上代码无法运行,


但是下面这种情况就能通行:
create proc info
as
declare @s varchar(5000)
begin
set @s= 'SELECT top 7 * from users order by id desc '
exec (@s)
end
go

前台调用:
set rs = server.createobject( "adodb.recordset ")
rs.Open " exec info ",conn,1,1

这样就能运行通过得到结果,晕那里错了,

[解决办法]
没给@topsl赋值
[解决办法]
'+@topsl+ '

???是用+的吗,还是&?

好久没动sql了,都忘啦.
还有 '这个,好像也不要的吧?