这个存储过程可以实现的吗？

[changxiang]

主要意思是向它传两个参数，其中一个要放在 select 的top 与 * 之间，如下写法不行，请教如何实现此功能，谢谢！

CREATE PROCEDURE up_ndp_getNewsByType
@type varchar(2),
@number int

AS
select top @number * from NewsInfo where NewsType = @type
GO

[changxiang]

还是不行，UP... ...

[dlkfth]

execute sp_executesql
N'select top @number * from NewsInfo where NewsType = @type',
N'@number INT',
N'@type INT',
参数1,
参数2

[caiyunxia]

exec ('select top '+ cast(@number as varcahr(10) +' * from NewsInfo where NewsType = '+ @type)

[dlkfth]

DECLARE @VCnumber varcahr(10)
SET @VCnumber=cast(@number as varcahr(10)
exec ('select top '+ @VCnumber +' * from NewsInfo where NewsType = '+ @type)

[mnm0756]

CREATE PROCEDURE SelectTopNumber
@number int
AS
SET ROWCOUNT @number
select * from authors order by au_ID
GO

[tjan]

动态SQL，用 exec 拼接你要执行的语句。

[mnm0756]

安安
你说的是什么方法呀，我想知道，难道是id>* and id<*

[changxiang]

按楼上的这样写为什么还是不行？：
create procedure up_name
@type varchar(2),
@number int

as

DECLARE @VCnumber varcahr(10)
SET @VCnumber=cast(@number as varcahr(10)
exec ('select top '+ @VCnumber +' * from NewsInfo where NewsType = '+ @type)