--你是不是应该定义2个变量 穿进去 declare @a1 int ,@a2 int set @1=2,@a2=3 select power(@a1,@a2)
大致是这样: create proc myPower(@d int,@e int) as declare @t int set @t=@d while @e>1 begin set @t=@t*@d set @e=@e-1 end select @t as result goexec myPower 2,3 --8drop proc myPower
declare @a1 int ,@a2 int
set @1=2,@a2=3
select power(@a1,@a2)
create proc myPower(@d int,@e int)
as
declare @t int
set @t=@d
while @e>1
begin
set @t=@t*@d
set @e=@e-1
end
select @t as result
goexec myPower 2,3 --8drop proc myPower