急需一个关于存储过程的问题

[oralxc]

写存储过程的时候在TOP时TOP参数也用变量怎么写
@id int,
@top int

select top @top * from DTable where id=@id

这个肯定是错的，大家请帮帮小弟啊~先谢啦~

[yangvxin1]

好象是:
declare @p1 varchar(100)

set @p1='select top '+cast(@top as varchar)+' * from DTable where id='+@id

exec(@p1)

[zarge]

declare @cmd nvarchar(255)

Set @cmd = 'select top ' + cast(@top as nvarchar)
+ ' * from DTable where id=' + cast(@id as nvarchar)

exec sp_executesql @cmd

[yangvxin1]

搞错了。id为int要转化.

declare @p1 varchar(100)

set @p1='select top '+cast(@top as varchar)+' * from DTable where id='+cast(@id as varchar)

exec(@p1)

[yangvxin1]

搞错了。id为int要转化.呵呵.不好意思.

declare @p1 varchar(100)

set @p1='select top '+cast(@top as varchar)+' * from DTable where id='+cast(@id as varchar)

exec(@p1)

[goneaway]

@id int,
@top int
@sql_str nvarchar(4000)
set sql_str='select top '+cast(@top as nvarchar)+' * from DTable where id='+cast(@id as nvarchar)
EXECUTE sp_executesql sql_str

[goneaway]

declare @id int
declare @top int
declare @sql_str nvarchar(4000)
set sql_str='select top '+cast(@top as nvarchar)+' * from DTable where id='+cast(@id as nvarchar)
EXECUTE sp_executesql sql_str

[liuyun2003]

exec('select top '+cast(@top as varchar)+' * from DTable where id='+cast(@id as varchar))

[oralxc]

谢谢大家了~