看一下存储过程，不知道哪错了，急死了

CREATE procedure GetNewsDetails
(
@typeid int,
@size int

)
as
select top @size newsid,newstitle,newsauthor,newshint,uploadtime from news where newstype=@typeid order by uploadtime desc

GO
我想动态的取出多少条新闻，可是说@size有错误，是不是那个地方不能这样用啊


[解决办法]
CREATE procedure GetNewsDetails
(
@typeid int,
@size int

)
as
declare @sql varchar(8000)

set @sql = 'select top ' + convert(varchar(10),@size) + ' newsid,newstitle,newsauthor,newshint,uploadtime from news where newstype= ' + convert(varchar(10),@typeid) + ' order by uploadtime desc '

EXECUTE sp_executesql @sql

GO