我不会这个问题?哪位 帮我解决?

[fengyatou]

if exists(select * from dbo.sysobjects where id=object_id(N'dbo.MultipleThreeValue')
and objectproperty(id,N'isprocedure')=1)
drop procedure dbo.MultipleThreeValue
go
create procedure MultipleThreeValue
@number1 int,
@number2 int,
@number3 int
as
return @number1*@number2*@number3
declare @CountResult int
execute @CountResult=MultipleThreeValue 19,34,59
select '19乘34乘59=',@CountResult
错误信息是:
无法在 sysdepends 中添加当前存储过程所对应的行，因为缺少该存储过程所依赖的对象 'MultipleThreeValue'。仍将创建该存储过程。
我要怎么样解决这个问题?

[sxdoujg]

create proc MultipleThreeValue
@number1 int,
@number2 int,
@number3 int
as
return @number1*@number2*@number3
go

declare @CountResult int
execute @CountResult=MultipleThreeValue 19,34,59
select '19乘34乘59=',@CountResult


少go!

[coowoo]

不需要解决

[xeqtr1982]

if exists(select * from dbo.sysobjects where id=object_id(N'dbo.MultipleThreeValue')
and objectproperty(id,N'isprocedure')=1)
drop procedure dbo.MultipleThreeValue
go

create procedure MultipleThreeValue
@number1 int,
@number2 int,
@number3 int,
@Countresult int OUTPUT
as
set @Countresult=@number1*@number2*@number3
go

declare @CountResult int
execute MultipleThreeValue 19,34,59,@CountResult OUTPUT
select '19乘34乘59='+cast(@CountResult as varchar) as 结果

[coowoo]

你的存储过程是递归调用，创建的时候当然还没有它自己
提示不是说了吗“仍将创建该存储过程。”

虽然有错误信息，但过程还是会建立

[itblog]

if exists(select * from dbo.sysobjects where id=object_id(N'dbo.MultipleThreeValue')
and objectproperty(id,N'isprocedure')=1)
drop procedure dbo.MultipleThreeValue
go
create procedure MultipleThreeValue
@number1 int,
@number2 int,
@number3 int
as
return @number1*@number2*@number3

go



declare @CountResult int
execute @CountResult=MultipleThreeValue 19,34,59
print @CountResult

select [19乘34乘59]=@CountResult