存储中如何传递如下参数:select top (参数1) id from mytable

[叶子哟]

参数1为一整数参数,为何不行

[hjhing]

exec ('select top '+ @int + ' [id] from myTable')

[pengdali]

declare @i
set @i=10
exec ('select top '+@i+ ' * from 表')

[叶子哟]

创建可以了，但运行时报错!
create procedure myproc1 @myint int
as
exec ('select top ' + @myint + ' * from allquestion')

[叶子哟]

唉，必须声明@myint 为类char型,已解决!!

[glboy]

create procedure myproc1 @myint int
as
exec ('select top ' + str(@myint) + ' * from allquestion')

不是可以了吗？加上str函数就可以声明为int啊