34,594
社区成员
发帖
与我相关
我的任务
分享求解！ 在存储过程中根据参数取前n行
大致意思是：
ALTER PROCEDURE mypro
@COMPOSITOR tinyint
AS
select top @COMPOSITOR * from t
但这样返回错误，该如何修改呢？多谢
ALTER PROCEDURE mypro
@COMPOSITOR tinyint
AS
select top @COMPOSITOR * from t
但这样返回错误，该如何修改呢？多谢
...全文
请发表友善的回复…
发表回复
comszsoft 2004-12-03
- 打赏
- 举报
楼上两位已经把问题解决了
xingfuniao 2004-12-03
- 打赏
- 举报
ALTER PROCEDURE mypro
@COMPOSITOR tinyint
AS
declare @sql varchar(1000)
set @sql='select top '+cast(@COMPOSITOR as varchar)+' * from t'
exec(@sql)
@COMPOSITOR tinyint
AS
declare @sql varchar(1000)
set @sql='select top '+cast(@COMPOSITOR as varchar)+' * from t'
exec(@sql)
tddw 2004-12-03
- 打赏
- 举报
declare @cmd varchar(8000)
set @cmd = 'select top ' + @COMPOSITOR + ' * from t'
exec(@cmd)
set @cmd = 'select top ' + @COMPOSITOR + ' * from t'
exec(@cmd)
