存储过程，查询时候出的问题

[durkingzhang]

create procduce a
@intPageSize int

as

begin


select top rtrim(convert(char,@intPageSize,10))
SN from Product

end


请问这句有什么问题？

[fcuandy]

sql2k只支持top后接常量

[lgxyz]

1:
rtrim(convert(char,@intPageSize,10))
这个括号错了吧
2:
应该用动态语句来

[中国风]

select top (@intPageSize) SN from Product --05以上版本

2000用動態
declare @i int
set @i=10
exec('select top '+@i+' ID from sysobjects')

[lgxyz]

[Quote=引用楼主 durkingzhang 的帖子:]
create procduce a
@intPageSize int

as

begin


select top rtrim(convert(char,@intPageSize,10))
SN from Product

end


请问这句有什么问题？
[/Quote]


10是什么意思?

[lgxyz]

create procedure a 
@intPageSize int 
as 
begin 
  declare @sql varchar(8000)
  set @sql='select top '+convert(varchar,@intPageSize)+' * from ta' 
  exec (@sql)
end 

[regithanhu]

你这是个变量需要用动态sql

alter procduce a 
@intPageSize int 
as 
begin 
  declare @s varchar(8000)
set @s='select  top  +rtrim(convert(char,+'@intPageSize'+,10))  
SN  from Product '
exec (@sql)

end