t-sql语句的存储过程不能用top+变量吗？

[dobly]

create procedure procname
@intCount int
as
select top @intCount from tablename


这句编译不能通过，奇怪

[lupenda]

改成：
create procedure procname
@intCount int
as
declare @str varchar(1000)
set @str='select top'+ @intCount+' from tablename'
exec @str

[uffeng]

create procedure procname
@intCount int
as
declare @str varchar(1000)
set @str='select top'+ @intCount+' from tablename'
exec (@str)

[as12a]

不可以

[zilang]

declare @str varchar(1000)
set @str='select top'+ @intCount+' (Your Column,etc * ) from tablename'
exec @str

[zilang]

declare @str varchar(1000)
set @str='select top'+ @intCount+' * from tablename'
exec @str

[whmjw]

你必须要先声明才行,

你那个只是参数而已